PostgreSQL connections

Tags:

If you are using an application that needs PostgreSQL connections

on your LAN, don't forget to add, or replace, in file postgresql.conf

listen_addresses ='*'

Otherwise, postgres will bind only to 'localhost' and won't be accessible from your network. You will just get Connection Refused errors until you add this parameter to enable listening to TCP sockets. (That's port 5432 if you look in /etc/services.)

NOTE: Webmin doesn't give you a way to edit the parameters in postgresql.conf, you'll have to do it manually.