From: | Holger Jakobs <holger(at)jakobs(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Connection pooler / LDAP auth / Load Balancing on read-only queries |
Date: | 2024-07-03 20:32:49 |
Message-ID: | 35925d5a-fc1a-4f94-bef2-7494e9345d6a@jakobs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Am 03.07.24 um 22:25 schrieb Achilleas Mantzios:
> Dear Members
>
> I am searching (like many others) of the holy grail of PostgreSQL
> pooling + Load Balancing . Ideally I would like :
>
> - A pgbouncer with better/native LDAP (not PAM) / and eventually
> Kerberos support
>
> - A pgbouncer enhanced with load balancing read-only queries (like
> pgpool)
>
> or
>
> - A pgpool-II with better resources utilization / more efficient
> pooling (like pgbouncer)
>
>
> There are other solutions available pgcat (no LDAP), odyssey (no load
> balancing) , pgagroal, supavisor, none of which seem to cover the above.
>
> Some ppl advice , keeping pgbouncer close to the app(s) and pgpool
> close to the DB. But kinda had mixed feelings putting the two work
> together.
>
> I'd like to ask if there any thoughts or even hopes that some of the
> above will be available in a single software, or otherwise how do
> people tackle this.
>
> Thank you
>
Have a look at pgCat, a newcomer which might meet your needs.
Cheers
Holger
--
Holger Jakobs, Bergisch Gladbach
From | Date | Subject | |
---|---|---|---|
Next Message | Achilleas Mantzios - cloud | 2024-07-04 06:38:07 | Re: Connection pooler / LDAP auth / Load Balancing on read-only queries |
Previous Message | Scott Ribe | 2024-07-03 20:32:29 | Re: Connection pooler / LDAP auth / Load Balancing on read-only queries |