Basic Install of PostgreSQL (Linux Ubuntu)

Hello folks,

Below there are a step by step explaining how to install PostgreSQL 8.3 on Linux Ubuntu.

Installing postgresql (8.3)

sudo apt-get install postgresql-8.3

Setting up the password for postgres’ postgres user

sudo -u postgres psql template1
ALTER USER postgres WITH PASSWORD 'your-password';
\q

Configure postgres’ authentication method :

sudo cp /etc/postgresql/8.3/main/pg_hba.conf /etc/postgresql/8.3/main/pg_hba.conf_bak
sudo vi /etc/postgresql/8.3/main/pg_hba.conf

Add the following at the bottom of the file

# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD
host    all         all         127.0.0.1       255.255.255.0    password