postgresql when it's not your job

20:51

Getting PostgreSQL 8.4 to only listen on Unix sockets

15 October 2009

The default installation of PostgreSQL listens on 127.0.0.1 (the local loopback address) and on Unix sockets. The controlling parameter, listen_addresses, isn’t documented to have a setting that just listens on sockets, and not the loopback address.

As it happens, such a setting exists:

listen_addresses=''

Among other things, this appears to prevent local instances of pgAdmin from connecting (although psql works fine), so its utility is not clear, but there it is if you wish it.

Comments are closed.