Re: Pgbouncer, docker and systemd

On 19.04.22 15:01, Kristjan Mustkivi wrote:
> Iam curious if anyone has tried to marry dockerized pgbouncer and systemd?
>
> Why? To get my own most up to date pgbouncer version independent of
> the OS provided package and coupled with systemd's offered port reuse
> and separate management ports.
>
> I happened to read
>
> * https://www.2ndquadrant.com/en/blog/running-multiple-pgbouncer-instances-with-systemd/
> * https://www.enterprisedb.com/postgres-tutorials/pgbouncer-setup-extended-architecture-use-cases-and-leveraging-soreuseport
>
> The main problem has been that the sd_notify call will not get out
> from the container and the host's systemctl start is left hanging
> until a timeout occurs. And I have compiled my own pgbouncer
> --with-systemd flag so it is probably a docker container feature.

I think for your what you are trying to set up here, docker and systemd
are competing approaches for launching services and they will fight or
hinder each other.

If all you want is an up to date pgbouncer package, perhaps you will
find what you need on apt.postgresql.org or yum.postgresql.org.