PostgreSQL configuration

Note: if you know postgres admin credentials but do not know the configuration details of an existing installation, this is a very handy DDL that will list all configration information:

select category, name, seting from pg_settings order by 1; 

1. Installation

1. sudo apt-get install postgresql postgresql-client postgresql-contrib (This installs the database server/client, some extra utility scripts)
2. sudo apt-get install pgadmin3 (This installs the pgAdmin GUI application for working with the database)
3. References
   1. https://help.ubuntu.com/community/PostgreSQL
   2. http://hocuspokus.net/2007/11/install-postgresql-on-ubuntu-710

...