Google Ads

Saturday, May 30, 2009

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';

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 password

No comments: