I don't know how to configure a application to connect to PostgreSQL over a unix socket, apparently. This is driving me crazy

Well, I felt this was it, but I was dumb in not checking it first. The issue was that php-fpm was not running as the correct user. For the peer connection to work, it needs to run the pool as the same Linux user. One step closer to a functioning @pixelfed instance.

in reply to self