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 1qBD67-0001UN-0j for pgsql-general@arkaria.postgresql.org; Mon, 19 Jun 2023 11:31:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qBD65-0005Rz-4e for pgsql-general@arkaria.postgresql.org; Mon, 19 Jun 2023 11:31:01 +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 1qBD64-0005Rq-QS for pgsql-general@lists.postgresql.org; Mon, 19 Jun 2023 11:31:00 +0000 Received: from prater.isola.red ([89.58.62.163]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qBD61-0032pp-Pp for pgsql-general@lists.postgresql.org; Mon, 19 Jun 2023 11:30:59 +0000 Received: from wm.joel-hatsch.net (unknown [172.29.0.3]) (Authenticated sender: michael@weiller.eu) by prater.isola.red (Postfix) with ESMTPSA id 5DE3CC1876; Mon, 19 Jun 2023 13:30:54 +0200 (CEST) MIME-Version: 1.0 Date: Mon, 19 Jun 2023 11:30:54 +0000 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable From: "Brainmue" Message-ID: Subject: Re: Question: Multiple pg clusters on one server can be reached with the standard port. To: "Dominique Devienne" , "Thomas Markus" Cc: pgsql-general@lists.postgresql.org In-Reply-To: References: <0c2dd853-08ec-dbed-00c3-a680ae711d89@proventis.net> <71943c04e05c3c13d5cd2b287909f351@weiller.eu> <20230619103335.xyagd43uhneducxz@hjp.at> <0894245c-d056-b9e5-62f5-c0ed39ad7ff1@proventis.net> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 19. Juni 2023 13:17, "Dominique Devienne" schrieb: > On Mon, Jun 19, 2023 at 1:01 PM Thomas Markus = wrote: >=20 >>=20Am 19.06.23 um 12:33 schrieb Peter J. Holzer: >>> As Francisco already pointed out, this can't work with nginx either. >> anyway, fw or nginx cant look into tcp streams > Traefik can proxy PostgreSQL, I've read, so maybe that's something you = could try. Thanks for the tip. As I understand Traefik but he can also only the same as HAProxy. So he does not read the protocol itself and can not make the distribution= . PGBouncer can actually do it and it also forwards to different backends. But we are not finished with the tests yet. But it looks already good. Regards Michael