MIME-Version: 1.0
References: 
 <CAOQPKaszN=425jdESsGOSxCYP4yL8skpwuAVB4y=Qb1CmpJNdw@mail.gmail.com>
 <250e40d4-a750-c960-3586-a01d99c780f2@enterprisedb.com>
In-Reply-To: <250e40d4-a750-c960-3586-a01d99c780f2@enterprisedb.com>
From: Kristjan Mustkivi <sonicmonkey@gmail.com>
Date: Wed, 20 Apr 2022 09:04:35 +0300
Message-ID: 
 <CAOQPKauSiceJ4zOjgyRi+VXrM4GZTyH_an6gjy1EeuDvKZx7Cw@mail.gmail.com>
Subject: Re: Pgbouncer, docker and systemd
To: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Cc: pgsql-admin@lists.postgresql.org
Content-Type: text/plain; charset="UTF-8"
Archived-At: 
 <https://www.postgresql.org/message-id/CAOQPKauSiceJ4zOjgyRi%2BVXrM4GZTyH_an6gjy1EeuDvKZx7Cw%40mail.gmail.com>
Precedence: bulk

On Tue, Apr 19, 2022 at 5:08 PM Peter Eisentraut
<peter.eisentraut@enterprisedb.com> wrote:
>
> 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.

Makes sense. Of course, there's a bit more: the environment where the
pgbouncer would be installed hosts different services packaged by many
teams and the standard for packaging is docker.

I will figure out a different approach. Thank you for the comments!

Best regards,
-- 
Kristjan Mustkivi

Email: kristjan.mustkivi@gmail.com