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.