Sunday, May 26, 3:50 am

Howto- Install PostgreSQL in Ubuntu11.10/12.04 and LinuxMint

Written by Mel Kham on April 11, 2012. Posted in Frequently Asked Questions, Linux Mint, Ubuntu

Queastion: How to install PostgreSQL on Ubuntu and Mint ?

Answer:

1- Instal postgresql using the command:

sudo apt-get install postgresql  libpq-dev

2- Now change the postgres user password (as root):

sudo su -npostgres
postgres@Mint12 ~ $ psql -d postgres -U postgres psql (9.1.3) Type "help" for help.
postgres=#
postgres=# alter user postgres with password 'a'; ALTER ROLE postgres=# q

Restart The Server after this change

3-To install GUI client pgsql

sudo apt-get install pgadmin3

Run the Client and stat creating users and databases

For questions please refer to our Q/A forum at : http://ask.unixmen.com

LinuxMint

Mel Kham

Founder of Unixmen, Living in Amsterdam. Am working in my free time to help people to understand the Opensource and to explain them in easy way how to make the fist steps to the the light. Working day and night with my Co-founder Zinovsky to keep this website live even with less resources.

Eusoubabdo

what the fuck cyclop…
thirdshopping

The article is very
exhaustive，Thank you.
thirdshopping

The article is very
exhaustive，Thank you.
thirdshopping

The article is very
exhaustive，Thank you.
http://www.about.me/briankung Brian Kung

Can you say specifically how to restart the postgres server?
Also, I can’t tell what is output from postgres and what is a command to be issued.

Thank you for the article, though.
pedrobl

The second point’s commands are not displayed clearly:

sudo su – postgres
postgres@Mint12 ~ $ psql -d postgres -U postgres
psql (9.1.3) Type “help” for help.
postgres=#
postgres=# alter user postgres with password ‘a’;
ALTER ROLE
postgres=# q
Hope it comes out right… :P
pedrobl

The second point’s commands are not displayed clearly:

sudo su – postgres
postgres@Mint12 ~ $ psql -d postgres -U postgres
psql (9.1.3) Type “help” for help.
postgres=#
postgres=# alter user postgres with password ‘a’;
ALTER ROLE
postgres=# q
Hope it comes out right… :P

Like us on Facebook

This week Top Posts

Top Things to do After Installing Ubuntu 13.04 ‘Raring Ringtail’ : Ubuntu 13.04 Raring Ringtail final is almost out. The final release it scheduled for release on Apri...0 comment(s) | by M. Zinoune
Howto: Upgrade to Ubuntu 13.04 Raring Ringtail from 12.04, 12,10 | Desktop & Server : Updated 05-04-2013: Ubuntu 13.04 Raring Ringtail will be released Soon, If you have ubuntu 12,10, 12...0 comment(s) | by M. Zinoune
Install lamp with 1 command in Ubuntu 12.10, 13.04 Raring Ringtail & LinuxMint13 : Updated: 10/09/2012 :LAMP (Linux, Apache, MySQL and PHP) is an open source Web development platform ...0 comment(s) | by Mel Kham
Configure conky-Lua in Ubuntu (12.10 & 13.04 Raring Ringtail), Fedora, debian and LinuxMint | Howto Conky : Updated 05-04-2013: Conky is a free, light-weight system monitor for X, that displays any informatio...0 comment(s) | by M. Zinoune
Howto- Resolve nosound problem on Ubuntu 13.04 Raring Ringtail,12.10 and Older : Updated 05/04/2013 : One of the common issues facing Ubuntu users after installing or upgrading Ubun...0 comment(s) | by M. Zinoune
Install and Configure Samba share in Ubuntu 13.04 Raring Ringtail , 12.10, 12.04| Howto : Updated 05-04-2013: One of the most asked features for Samba is a graphical user interface to help w...0 comment(s) | by Mel Kham