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 1qACxJ-00079Y-7Q for pgsql-general@arkaria.postgresql.org; Fri, 16 Jun 2023 17:09:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qACxH-0006ER-RN for pgsql-general@arkaria.postgresql.org; Fri, 16 Jun 2023 17:09:47 +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 1qACxH-0006Cl-GW for pgsql-general@lists.postgresql.org; Fri, 16 Jun 2023 17:09:47 +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 1qACwi-002Z4V-Mm for pgsql-general@lists.postgresql.org; Fri, 16 Jun 2023 17:09:14 +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 B8286CB19B for ; Fri, 16 Jun 2023 19:09:08 +0200 (CEST) MIME-Version: 1.0 Date: Fri, 16 Jun 2023 17:09:08 +0000 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable From: "Brainmue" Message-ID: <8efe091e9971085263e3f5509c1eef5a@weiller.eu> Subject: Re: Question: Multiple pg clusters on one server can be reached with the standard port. To: pgsql-general@lists.postgresql.org In-Reply-To: References: <0c2dd853-08ec-dbed-00c3-a680ae711d89@proventis.net> <71943c04e05c3c13d5cd2b287909f351@weiller.eu> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 16. Juni 2023 18:19, "Jeff Ross" schrieb: >> We have already looked at pgbouncer and it works with that but unfortu= nately you have to do the >> authentication in pgbouncer. Which we don't like so much. >> Regards, >> Michael > You can set up pgbouncer to authenticate in postgres: >=20 >=20https://www.2ndquadrant.com/en/blog/understanding-user-management-in-= pgbouncer/ > See the "auth_query, auth_user" section. >=20 >=20https://www.2ndquadrant.com/en/blog/pg-phriday-securing-pgbouncer/ >=20 >=20Jeff Thanks for the links. We'll take a second look then. I remember that we had problems last time, but unfortunately I can't reme= mber which ones. Regards Michael