Jul 8, 2007

Configure PostgreSQL

To connect from other host than locahost
- In file postgresql.conf (/var/lib/pgsql/data/postgresql.conf)
Change or add
listen_addresses = "*"
- In file pg_hba.conf
Allow connect from localhost
host all all 192.168.1.0/24 trust
Allow connect from internet
host all all 0.0.0.0/0 trust

note
0.0.0.0/a mean that IP in a range of 0.0.0.0 with a bits is fixed

No comments: