On Thursday 06 Sep 2012 09:37:51 you wrote:
Yeah, I spotted that too, and this is probably related, but I'm not getting a hang. After the segfault, php-fpm actually continues to work (maybe just the worker dies and a new one is spawned?), and phpMyAdmin works with MySQL just fine, but phpPgAdmin doesn't, even though Postgres is clearly operating correctly.
Very strange...(Penny Lane...)
It's been a tough week (evidenced by the fact that I posted to the list in frustration), and it turns out I wasn't careful enough with my basic checks. The problem was exactly what I thought it was originally: the systemd unit file for php-fpm must have PrivateTmp=false, or it won't see the Postgres socket. Bug tracker ticket created: https://bugs.archlinux.org/task/31436 All the other failures were because Firefox was remembering the wrong login details for phpPgAdmin. (Schoolboy error!) Simple fix: create /etc/systemd/system/php-fpm.service with the following contents: ------- .include /usr/lib/systemd/system/php-fpm.service [Service] PrivateTmp=false ------- This makes things work for me. The segfaulting still happens, but isn't a blocker for me, as the service works fine despite it. Paul