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.