Ranting and Raving

PostgreSQL 8.4 on Ubuntu 9.10 (Karmic)

Getting PostgreSQL installed on Ubuntu is pretty straight forward as standard .deb packages already exist for the db in Ubuntu’s repository system. However beyond getting the package installed there are a couple of configuration steps that are required to complete the basic configuration of the PostgreSQL Db System.

Install the DB and associated packages

Reset the default postgres db password

Reset the default postgres system password

Backup/Edit the postgresql.conf file

Backup/Edit the pg_hba.conf file

Restart the Db

Create a new db user and new database

Install the DB and associated packagesThe database and any prerequisite packages: