major.io words of wisdom from a systems engineer

Postgresql not listening on network

On some operating systems, postgresql is not configured to listen on the network. To enable the TCP/IP connections, edit the /var/lib/pgsql/data/postgresql.conf and change the following:

tcpip_socket = true
port = 5432

Restart postgresql and you should be all set:

/etc/init.d/postgresql restart