From: Michael Banck <mbanck@gmx.net>
To: Ninad Shah <ninad.shah@percona.com>
Cc: Anjul Tyagi <anjul@ibosstech-us.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Client IP in Patroni
Date: Mon, 21 Nov 2022 20:07:56 +0100
Message-ID: <637bcc8d.170a0220.d85c0.6cb3@mx.google.com> (raw)
In-Reply-To: <CAMtEjOa5vv9ZQEKsGNH_DC857LOPg314Kfg4QaXmVTq+myy=TQ@mail.gmail.com>
References: <em93afa279-dd83-4c24-83fb-d087c8eb3449@4cf9dad7.com>
<CAMtEjOa5vv9ZQEKsGNH_DC857LOPg314Kfg4QaXmVTq+myy=TQ@mail.gmail.com>
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
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: mbanck@gmx.net, ninad.shah@percona.com, anjul@ibosstech-us.com
Subject: Re: Client IP in Patroni
In-Reply-To: <637bcc8d.170a0220.d85c0.6cb3@mx.google.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