Starting Postgress SQL

Install It
apt-get install postgresql-9.1

Create a user
sudo -u postgres createuser -d -R -P

Give a password for the user.
sudo -su postgres

postgres$  psql -U postgres

ALTER USER postgres with password 'secure-password';

now you can directly connect from Super User like this
psql -U postgres -h localhost


Create a database

createdb mydb

Export from one db to another

pg_dump -C -h localhost -U localuser dbname | psql -h remotehost -U remoteuser 

Take a dump
pg_dump -c -U postgres ${fromDataBase} -f ABIMS9JAN13tabledump.sql -h ${fromHost}

Execute the dump
psql -d ${toDataBase} -f dumpfilename.sql -h ${toHost} -U postgres -w password

Install GUI
sudo apt-get install pgadmin3

pgadmin3

pg_dump --username "postgres" -Fc origin > origin.dump


pg_restore --username "postgres" -d target origin.dump