Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\))
Subject: Re: Connection pooler / LDAP auth / Load Balancing on read-only
 queries
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: <1745e084-a408-445f-97e3-44e29977ccc5@cloud.gatewaynet.com>
Date: Wed, 3 Jul 2024 14:32:29 -0600
Cc: pgsql-admin@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <D20C9519-9AEB-411E-A49A-584CFB4678D5@elevated-dev.com>
References: <1745e084-a408-445f-97e3-44e29977ccc5@cloud.gatewaynet.com>
To: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
Archived-At: 
 <https://www.postgresql.org/message-id/D20C9519-9AEB-411E-A49A-584CFB4678D5%40elevated-dev.com>
Precedence: bulk

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=E2=80=AFPM, Achilleas Mantzios =
<a.mantzios@cloud.gatewaynet.com> wrote:
>=20
> Dear Members
>=20
> I am searching (like many others) of the holy grail of PostgreSQL =
pooling + Load Balancing . Ideally I would like :
>=20
> - A pgbouncer with better/native LDAP (not PAM) / and eventually =
Kerberos support
>=20
> - A pgbouncer enhanced with load balancing read-only queries (like =
pgpool)
>=20
> or
>=20
> - A pgpool-II with better resources utilization / more efficient =
pooling (like pgbouncer)
>=20
>=20
> There are other solutions available pgcat (no LDAP), odyssey (no load =
balancing) , pgagroal, supavisor, none of which seem to cover the above.
>=20
> 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.
>=20
> 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.
>=20
> Thank you
>=20
> --=20
> Achilleas Mantzios
> IT DEV - HEAD
> IT DEPT
> Dynacom Tankers Mgmt (as agents only)
>=20
>=20
>=20