I have a scenario when I need to run pgbouncer with postgres' pg_hba.conf permissions file. Since there I have a large cluster of postgres instances I cannot maintain pairs of postgres and pgbouncer pg_hba.conf files. Meanwhile, patroni, which I use for administering clusters, provides a utility that updates postgres pg_hba.conf for all instances. Problem is that pgbouncer's pg_hba.conf is still unmaintained. pgbouncer allows users to use pg_hba.conf directly from postgres, but by default this file can be accessed only by postgres user while pgbouncer runs with its own user. It would be great to add an option to init.d/conf.d files to allow defining your own user to run with. Upstream proposes using postgres user on starting systemd unit service.
