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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1oxC9E-0001u1-Ax
	for pgsql-admin@arkaria.postgresql.org; Mon, 21 Nov 2022 19:08:04 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1oxC9D-0006ui-5c
	for pgsql-admin@arkaria.postgresql.org; Mon, 21 Nov 2022 19:08:03 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <mbanck@gmail.com>)
	id 1oxC9C-0006uZ-O3
	for pgsql-admin@lists.postgresql.org; Mon, 21 Nov 2022 19:08:02 +0000
Received: from mail-ej1-x62f.google.com ([2a00:1450:4864:20::62f])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <mbanck@gmail.com>)
	id 1oxC9A-0000N3-Bg
	for pgsql-admin@postgresql.org; Mon, 21 Nov 2022 19:08:02 +0000
Received: by mail-ej1-x62f.google.com with SMTP id m22so30676832eji.10
        for <pgsql-admin@postgresql.org>;
 Mon, 21 Nov 2022 11:07:59 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20210112;
        h=user-agent:in-reply-to:content-disposition:mime-version:references
         :subject:cc:to:from:date:sender:message-id:from:to:cc:subject:date
         :message-id:reply-to;
        bh=9ygTgi55dKJntHmr4mmKzavaUMqTIPFJ5hmiuUL6E1Y=;
        b=E7NViAgRm7rEDAVvDF51saVsNTMxCLaGYwl8L7fOjL3ftbD9TOX79wcv5orTMRGHFf
         mSIxy8p8X8EiyjmJvkn3cMaj76su92VBU544gHyOcAZmxTxxo6zH5sRHgzAEuzV53bHm
         K21M4FEiXqdSTwue3UOq+YFyiSHQICweJ3+EXPfOwNQZffcRhAMS+5y55o65LJhOd/Vz
         Qxz+3t/9jJx87ogbQVEkN66POxWklWQdxy5/GiujTPLUF8XLfOiw+uTHE+z1aTOOJLSg
         b+QulEMI3lTXAtDqOP5EPqbltbggQNkiBgTrPg4/BdAKhCRzCw9+sSI89W4Rzg6RYO6D
         CVJQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20210112;
        h=user-agent:in-reply-to:content-disposition:mime-version:references
         :subject:cc:to:from:date:sender:message-id:x-gm-message-state:from
         :to:cc:subject:date:message-id:reply-to;
        bh=9ygTgi55dKJntHmr4mmKzavaUMqTIPFJ5hmiuUL6E1Y=;
        b=JpR6onD34LpHoZwltmnKKTP8z7GENnRWD3gzcGIuJqfcw6sp9vq/7T5qXgYaih2GIu
         xjmeULS1nSmMXY5oPscaEG3v6RcG0I5G8ULbeSyr1DzL5LLSv50gQ3kPZj2uMqK/Ohw/
         7JB0WBwToZiqA0czl2TBoPX1/CGAMrmH4AGBIWbsbvBC3uhM4B+65jI9NgNV+SWgvJOC
         zPNLm5u9PHjf15ETyIOp5UEC86uLsACjglw6zzCyS15GckS3orlsMaZgotbdfS8lHaHO
         Jl5m2tl4KARYIuimpLgmCEfjO9UMRNw1Ahwdi3m1HyVY6U9ON4oDVNgTVqt4QJbdcujG
         pJfg==
X-Gm-Message-State: ANoB5plC/27hVVJm9a0Zn5ptxGGROHHB9zJ6vp80PWodEgTyDIZ4hOF7
	+0oujEWet8lUd4Csb1z0B6o=
X-Google-Smtp-Source: 
 AA0mqf66RQmq7wf5Z9q3+8jGIN2eQO9W3GpOjfSBhmUSIow2Z9nEfHRIXq+rNFOCPB7Sd6XfI5BTfw==
X-Received: by 2002:a17:907:3ac5:b0:78d:5d4a:c12f with SMTP id
 fi5-20020a1709073ac500b0078d5d4ac12fmr17186364ejc.421.1669057678163;
        Mon, 21 Nov 2022 11:07:58 -0800 (PST)
Received: from lightning.caipicrew.dd-dns.de
 ([2001:a61:3b5d:8501:b5d2:ef50:df61:ae38])
        by smtp.gmail.com with ESMTPSA id
 fy21-20020a170906b7d500b0077d6f628e14sm5226861ejb.83.2022.11.21.11.07.57
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Mon, 21 Nov 2022 11:07:57 -0800 (PST)
Message-ID: <637bcc8d.170a0220.d85c0.6cb3@mx.google.com>
X-Google-Original-Message-ID: 
 <20221121190756.GR9987@caipicrew.dd-dns.de;lightning.caipicrew.dd-dns.de>
Sender: Michael Banck <mbanck@gmail.com>
Received: from mbanck by lightning.caipicrew.dd-dns.de with local (Exim 4.92)
	(envelope-from <mbanck@caipicrew.dd-dns.de>)
	id 1oxC96-0006in-N1; Mon, 21 Nov 2022 20:07:56 +0100
Date: Mon, 21 Nov 2022 20:07:56 +0100
From: Michael Banck <mbanck@gmx.net>
To: Ninad Shah <ninad.shah@percona.com>
Cc: Anjul Tyagi <anjul@ibosstech-us.com>,
	pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Client IP in Patroni
References: <em93afa279-dd83-4c24-83fb-d087c8eb3449@4cf9dad7.com>
 <CAMtEjOa5vv9ZQEKsGNH_DC857LOPg314Kfg4QaXmVTq+myy=TQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAMtEjOa5vv9ZQEKsGNH_DC857LOPg314Kfg4QaXmVTq+myy=TQ@mail.gmail.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/637bcc8d.170a0220.d85c0.6cb3%40mx.google.com>
Precedence: bulk

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