public inbox for [email protected]  
help / color / mirror / Atom feed
Pgbouncer, docker and systemd
3+ messages / 2 participants
[nested] [flat]

* Pgbouncer, docker and systemd
@ 2022-04-19 13:01  Kristjan Mustkivi <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Kristjan Mustkivi @ 2022-04-19 13:01 UTC (permalink / raw)
  To: [email protected]

Dear all,

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-...

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.


Cheers,
-- 
Kristjan Mustkivi

Email: [email protected]





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Pgbouncer, docker and systemd
@ 2022-04-19 14:08  Peter Eisentraut <[email protected]>
  parent: Kristjan Mustkivi <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Peter Eisentraut @ 2022-04-19 14:08 UTC (permalink / raw)
  To: Kristjan Mustkivi <[email protected]>; [email protected]

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-...
> 
> 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.





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Pgbouncer, docker and systemd
@ 2022-04-20 06:04  Kristjan Mustkivi <[email protected]>
  parent: Peter Eisentraut <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Kristjan Mustkivi @ 2022-04-20 06:04 UTC (permalink / raw)
  To: Peter Eisentraut <[email protected]>; +Cc: [email protected]

On Tue, Apr 19, 2022 at 5:08 PM Peter Eisentraut
<[email protected]> 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-...
> >
> > 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: [email protected]






^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2022-04-20 06:04 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-04-19 13:01 Pgbouncer, docker and systemd Kristjan Mustkivi <[email protected]>
2022-04-19 14:08 ` Peter Eisentraut <[email protected]>
2022-04-20 06:04   ` Kristjan Mustkivi <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox