PostgreSQL Installation and configuration detailed

Installation:
sudo apt-get install PostgreSQL


Set Password
Sudo-u Postgres Psql
postgres=# ALTER USER postgres with PASSWORD ' postgres ';
postgres=# \q


sudo passwd-d postgres
Sudo-u Postgres passwd


Change the configuration file
sudo vim/etc/postgresql/8.4/main/postgresql.conf
listen_addresses = ' * '
Password_encryption = On


sudo vim/etc/postgresql/8.4/main/pg_hba.conf
Host All 0.0.0.0/0 MD5
Sudo/etc/init.d/postgresql restart


Test connection
Psql-u postgres-h 127.0.0.1
postgres=#


Installing GUI management tools
sudo apt-get install pgadmin3


Unloading
Dpkg--list | grep PostgreSQL
Dpkg--purge
Later reinstallation using aptitude to install PostgreSQL, you can regain all the configuration files

Http://blog.chinaunix.net/uid-25885064-id-3404550.html

PostgreSQL Installation and configuration detailed