Bug 893756

Summary:	dev-db/pgbouncer: allow to start service with another user (postgres)
Product:	Gentoo Linux	Reporter:	Azamat H. Hackimov <azamat.hackimov>
Component:	Current packages	Assignee:	PgSQL Bugs <pgsql-bugs>
Status:	UNCONFIRMED ---
Severity:	normal
Priority:	Normal
Version:	unspecified
Hardware:	All
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---

Description Azamat H. Hackimov 2023-02-09 09:43:49 UTC

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.