Re: Client IP in Patroni - Mailing list pgsql-admin

From Michael Banck
Subject Re: Client IP in Patroni
Date
Msg-id 637bcc8d.170a0220.d85c0.6cb3@mx.google.com
Whole thread Raw
In response to Re: Client IP in Patroni  (Ninad Shah <ninad.shah@percona.com>)
List pgsql-admin
Hi,

On Tue, Nov 22, 2022 at 12:27:38AM +0530, Ninad Shah wrote:
> Also, it is not compulsory to use HAProxy as a front of Patroni. You
> may use Pgbouncer instead of HAProxy as well, however there some
> concerns associated with it.

Another option would be to use vip-manager in order to maintain a
virtual ip on the leader node, or to use client-based failover by
putting all Patroni hosts in the connection string along with the
target_session_attrs option.


Michael



pgsql-admin by date:

Previous
From: Ninad Shah
Date:
Subject: Re: Client IP in Patroni
Next
From: Frank Rueter
Date:
Subject: Re: user credentials rejected by pgAdmin right after new install