PostgreSQL Need To Know

Installation

# apt-get install postgresql-8.3 postgresql-contrib-8.3

Note:

postgresql-contrib-8.3 contains additional facilities for postgresql

Configuration file location

# /etc/postgresql/8.3/main/postgresql.conf

# /etc/postgresql/8.3/main/pg_hba.conf

Actual location is /var/lib/postgresql/8.3/main/postgresql.conf

To configure connection for postgresql, edit pg_hba.conf

# "local" is for Unix domain socket connections only
local     all     all     ident sameuser (default) -> meaning database user does not need password for database editin.

It should be changed from ident sameuser to md5, this will require password login for database user for security purposes.