Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

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 packagesAssignee: PgSQL Bugs <pgsql-bugs>
Status: UNCONFIRMED ---    
Severity: normal    
Priority: Normal    
Version: unspecified   
Hardware: All   
OS: Linux   
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.