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
