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

This entry was posted on 21/05/2007 (Monday) at 9:04 am and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.
Printed from: http://rackerhacker.com/2007/05/21/postgresql-not-listening-on-network/ .
© Major Hayden 2012.

1 Comment   »

  • Alex says:
    27.03.12 at 07:50

    Thanks! on Debian (squeeze) the directory was '/etc/postgresql/8.4/main/'.


RSS feed for comments on this post

Leave a Reply

 

  • Welcome! I started this blog as a way to give back to all of the other system administrators who have taught me something in the past. Writing these posts brings me a lot of enjoyment and I hope you find the information useful. If you spot something that's incorrect or confusing, please write a comment and let me know. Drop me a line if there's something you want to know more about and I'll do my best to write a post on the topic.
    -- Major Hayden

    Flattr this