Saturday, January 15, 2011

Configure postgres to listen for remote connections

This might help... http://www.turnkeylinux.org/forum/support/20091102/openbravo-network-connect-postgresql-server

Configure postgres to listen for remote connections

CONF=/etc/postgresql/8.3/main/postgresql.conf
sed -i "s/#listen_addresses = 'localhost'/listen_addresses = '*'/" $CONF
Configure postgres to accept remote connections




# configure postgres to accept remote connections
cat >> /etc/postgresql/8.3/main/pg_hba.conf <
# Accept all IPv4 connections - CHANGE THIS!!!
host    all         all         0.0.0.0/0             md5
EOF