pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Connection pooler / LDAP auth / Load Balancing on read-only queries
Date: Wed, 3 Jul 2024 14:32:29 -0600
Message-ID: <D20C9519-9AEB-411E-A49A-584CFB4678D5@elevated-dev.com> (raw)
In-Reply-To: <1745e084-a408-445f-97e3-44e29977ccc5@cloud.gatewaynet.com>
References: <1745e084-a408-445f-97e3-44e29977ccc5@cloud.gatewaynet.com>

the read only detection is tricky--consider transaction level pooling, and the first query is read only

--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/



> On Jul 3, 2024, at 2:25 PM, Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com> wrote:
> 
> 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
> 
> -- 
> Achilleas Mantzios
> IT DEV - HEAD
> IT DEPT
> Dynacom Tankers Mgmt (as agents only)
> 
> 
> 

view thread (7+ messages)  latest in thread

Message-ID: <D20C9519-9AEB-411E-A49A-584CFB4678D5@elevated-dev.com>
Permalink:  ../D20C9519-9AEB-411E-A49A-584CFB4678D5@elevated-dev.com/
Also on:    postgresql.org/message-id/D20C9519-9AEB-411E-A49A-584CFB4678D5@elevated-dev.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott_ribe@elevated-dev.com, a.mantzios@cloud.gatewaynet.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Connection pooler / LDAP auth / Load Balancing on read-only queries
  In-Reply-To: <D20C9519-9AEB-411E-A49A-584CFB4678D5@elevated-dev.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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