How to Enable Remote Access to PostgreSQL Server

Thursday, March 10, 2011

OS: ubuntu

$ sudo vi /etc/postgresql/8.4/main/postgresql.conf

    listen_addresses = '*'
    password_encryption = on

$ sudo vi /etc/postgresql/8.4/main/pg_hba.conf

    host    all         all         192.168.0.0/24        trust

This entry was tagged PostgreSQL

comments powered by Disqus

© 2009-2013 lxneng.com. All rights reserved. Powered by Pyramid

go to Top