Postgres Pro
Downloads
Home   >   mailing lists

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

From Ninad Shah
Subject Re: Client IP in Patroni
Date
Msg-id CAMtEjOa5vv9ZQEKsGNH_DC857LOPg314Kfg4QaXmVTq+myy=TQ@mail.gmail.com
Whole thread Raw
In response to Client IP in Patroni  ("Anjul Tyagi" <anjul@ibosstech-us.com>)
Responses Re: Client IP in Patroni
List pgsql-admin
Tree view
Hi Anjul,

There is not a simple solution to it, because as Jim already mentioned that HAproxy works on the 4th layer for PostgreSQL, it is difficult for HAproxy to meet the expectations here.

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.


Thanks,

--

Ninad Shah
 PostgreSQL DBA I, Managed Services

 e: ninad.shah@percona.com

 w: www.percona.com

Databases Run Better with Percona. 




On Mon, Nov 21, 2022 at 8:44 PM Anjul Tyagi <anjul@ibosstech-us.com> wrote:
Team,

We have setup in Postgres HA Cluster using Patroni. Also we have used the HAProxy for load balancing...

On Postgres side, we are getting HaProxy IP instead of Client IP, while checking in pg_stat_activity tables. Can you please suggest the changes needs to be done on HAProxy or Postgres side? 

 
 
 


Regards,


Anjul TYAGI

Group Technical Manager


If a solution exists, I’ll deliver it; If it doesn't exist, I’ll create it


ü Go Green


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Out of memory error during pg_upgrade in big DB with large objects
Next
From: Michael Banck
Date:
Subject: Re: Client IP in Patroni