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