Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ox8VV-0007KP-Sj for pgsql-admin@arkaria.postgresql.org; Mon, 21 Nov 2022 15:14:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ox8VU-0003jy-O5 for pgsql-admin@arkaria.postgresql.org; Mon, 21 Nov 2022 15:14:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ox8VU-0003jp-BR for pgsql-admin@lists.postgresql.org; Mon, 21 Nov 2022 15:14:48 +0000 Received: from iboss.serversfarm.com ([78.46.80.142]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ox8VR-000519-Ez for pgsql-admin@postgresql.org; Mon, 21 Nov 2022 15:14:47 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=ibosstech-us.com; s=x; h=Content-Type:MIME-Version:Reply-To:Message-Id:Date :Subject:To:From:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc :Resent-Message-ID:In-Reply-To:References:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=qr7uKLeaFeKlXGKxTeKRY35MG1mOgcbA5w6Tnwzodaw=; b=BMCyaxO4tWjFWlVY+isTvrgCFu 91oA4jtrKPjR1Me2kiNby0oeO1cJOOKH7x96pCwhsze+AOcUtGvskmndUj+Q+LE/UICGLxTc1Kce1 Hg5Ju5+2yCY7x14nD3ZupHNQ+GnZyJlvtyOcXHYhCTp6rp8Xr/cO1A01wClygEhDZE/4Q0CW+QifY +EysPDkivnylBewNQTj0KIhKkZRidENdA2EdpLUVUjb/pBh5V33Or0beivTq6/OxQlFYoltbW4gQs red5+ZH2odGrfpBXK3nhZfHk1jot7KU7UtcKsSGMqwNVfdKJFTqdVF5lieIynA51P1LZa5ci64YW1 WiAxBhZw==; Received: from [122.161.51.184] (helo=[192.168.1.9]) by iboss.serversfarm.com with esmtpsa (TLS1.2) tls TLS_ECDHE_ECDSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ox8VR-0061WM-02 for pgsql-admin@postgresql.org; Mon, 21 Nov 2022 16:14:45 +0100 From: "Anjul Tyagi" To: pgsql-admin Subject: Client IP in Patroni Date: Mon, 21 Nov 2022 15:14:40 +0000 Message-Id: Reply-To: "Anjul Tyagi" User-Agent: eM_Client/9.2.1222.0 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="------=_MBEC681645-AFB4-40E2-B6C2-AA6D561E947C" X-Authenticated-Id: anjul@ibosstech-us.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --------=_MBEC681645-AFB4-40E2-B6C2-AA6D561E947C Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: quoted-printable Team, We have setup in Postgres HA Cluster using Patroni. Also we have used=20 the HAProxy for load balancing... On Postgres side, we are getting HaProxy IP instead of Client IP, while=20 checking in pg_stat_activity tables. Can you please suggest the changes=20 needs to be done on HAProxy or Postgres side? Regards, Anjul TYAGI Group Technical Manager If a solution exists, I=E2=80=99ll deliver it; If it doesn't exist, I=E2=80= =99ll create=20 it =C3=BC Go Green --------=_MBEC681645-AFB4-40E2-B6C2-AA6D561E947C Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Team,

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

On Postgres side, we are getting HaProxy IP instea= d of Client IP, while checking in pg_stat_activity tables. Can you please s= uggest the changes needs to be done on HAProxy or Postgres side?=C2=A0

=C2=A0
=C2=A0
=C2=A0


= Regards,


Anjul TYAGI

Group Technical Manager<= /span>


If a solution exists, I=E2=80=99ll deliv= er it; If it doesn't exist, I=E2=80=99ll create it


=C3=BC=C2=A0Go=C2=A0Green

=

--------=_MBEC681645-AFB4-40E2-B6C2-AA6D561E947C--