Today I was trying to make changes to a postgresql wrapper cookbook to get it to
accept connections from it’s hostname, but ran into issues when our recipes that
create databases tried to do it by talking to postgresql on localhost. Turns out
if you change postgresql’s
listen_address to the hostname, postgresql stops
listening on localhost.
The solution is to change the listen address configuration to
'*', which has
postgresql accept requests from anywhere.