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


Please shareShare on Facebook0Share on Google+18Tweet about this on Twitter13Share on LinkedIn0Share on Reddit0Digg thisShare on StumbleUpon0Share on VKBuffer this page

Queastion:  How to install PostgreSQL  on Ubuntu and Mint  ?


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=# 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