/etc/httpd/conf.d/auth_pgsql.conf could do with a couple of examples like the ones in /etc/httpd/conf.d/perl.conf.
Fixed in 0.9.12-10.