On 11/21/22 09:14, Anjul Tyagi wrote:
#x4c7f8ad52f284f3 #xc9d58b400fe04aa4b229b62f4952033b p.MsoNormal
{margin: 0in; font-size: 11pt; font-family: Calibri, sans-serif;}#x4c7f8ad52f284f3 #xf5dcd4e5bcaf4cd793556e604d1ae148 p.MsoNormal
{font-size: 11pt; font-family: Calibri, sans-serif; margin: 0in 0in 0pt;}blockquote.cite { margin-left: 5px; margin-right: 0px; padding-left: 10px; padding-right:0px; border-left: 1px solid #cccccc }blockquote.cite2 {margin-left: 5px; margin-right: 0px; padding-left: 10px; padding-right:0px; border-left: 1px solid #cccccc; margin-top: 3px; padding-top: 0px; }a img { border: 0px; }li[style='text-align: center;'], li[style='text-align: center; '], li[style='text-align: right;'], li[style='text-align: right; '] { list-style-position: inside;}body { font-family: Calibri; font-size: 11pt; }.quote { margin-left: 1em; margin-right: 1em; border-left: 5px #ebebeb solid; padding-left: 0.3em; }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?
Postgresql does not know that HAProxy is a proxy. It just knows that an IP address (which just happens to come from an HAProxy server) has connected and "doing stuff".
--
Angular momentum makes the world go 'round.