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

by

Please shareShare on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInShare on RedditDigg thisShare on StumbleUpon

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