How to send client ip at bakend using percona-ha

PostgreSQL
1

I have configured percona cluster and in front of it using percona -ha so to redirect request primary and replica but i want to handle in ha proxy so it should send the client ip at backend and we can whitelist that client ip using pg_hba.conf

Thanks in advance for the help

2

Hi @ashishpilania18,

The following blogpost shows how to set up HA Proxy and Postgres:

In particular, check the “A sample HAProxy configuration file is given below” section for how to direct traffic to replicas.

3

Dear Agustin

This is not solving the problem as we want HA proxy to send the client IP in the backward and through which we can handle client using pg_hba.conf as currently it is set for 0.0.0.0/0