MyNixOS website logo
option

services.pgbouncer.authQuery

Query to load user's password from database.

Direct access to pg_shadow requires admin rights. It's preferable to use a non-superuser that calls a SECURITY DEFINER function instead.

Note that the query is run inside the target database. So if a function is used, it needs to be installed into each database.

Declarations
Type
null or string
Default
null
Example
"SELECT usename, passwd FROM pg_shadow WHERE usename=$1"