Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 893756 - dev-db/pgbouncer: allow to start service with another user (postgres)
Summary: dev-db/pgbouncer: allow to start service with another user (postgres)
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal normal (vote)
Assignee: PgSQL Bugs
Depends on:
Reported: 2023-02-09 09:43 UTC by Azamat H. Hackimov
Modified: 2023-02-09 20:34 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Note You need to log in before you can comment on or make changes to this bug.
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.