Skip to content


Enable PostgreSQL access through the Network

Most wanted question:
1. How do I access PostgreSQL through the network?
1.1. Open postgresql.conf (in Ubuntu 8.04 at /etc/postgresql/8.3/main/postgresql.conf) and change listen_addresses = ‘localhost’ to listen_addresses = ‘*’.
1.2. Uncomment password_encryption = on.
1.3. Open /etc/postgresql/8.3/main/pg_hba.conf
host all all / trust
eg. host all all 192.168.2.0/24 trust
1.4. Restart PostgreSQL
/etc/init.d/postgresql-8.3

Yes! That works fine!

Posted in Knowledge Base.

Tagged with .


0 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.



Some HTML is OK

or, reply to this post via trackback.