After installation tips PostgreSQL

Added by Kees de Kooter, last edited by Kees de Kooter on Nov 13, 2008  (view change)

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 /var/lib/pgsql/data/postgresql.conf 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

Labels

 
(None)