After installation tips PostgreSQL

Intro

These notes are applicable to PostgreSQL version 8.3, running on Ubuntu 8.10.

Modify database user

First of all we need to set the password for the postgres database user.

sudo su postgres -c psql template1
template1=# ALTER USER postgres WITH PASSWORD 'postgres';
template1=# \q

Use pgAdmin

If you use the latest pgAdmin on the box you are installing Postgres it will advise on further configuration adjustments to be made. For older versions below is some more configuration info.

Networking

For a postgresql installation to accept external (TCP/IP) connections the file postgresql.conf (location depends on distro) has to be edited:

listen_addresses = '*'

Next the file pg_hba.conf has to be modified:

host all all 10.10.10.0/24 trust
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.