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 1qA8fW-0004VX-Lp for pgsql-general@arkaria.postgresql.org; Fri, 16 Jun 2023 12:35:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qA8fU-0003fP-RW for pgsql-general@arkaria.postgresql.org; Fri, 16 Jun 2023 12:35:08 +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 ) id 1qA8fU-0003fG-H1 for pgsql-general@lists.postgresql.org; Fri, 16 Jun 2023 12:35:08 +0000 Received: from prater.isola.red ([2a0a:4cc0:1:4e:2442::2]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qA8fR-002mq6-Vw for pgsql-general@lists.postgresql.org; Fri, 16 Jun 2023 12:35:07 +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 9B7D6C09FB; Fri, 16 Jun 2023 14:35:04 +0200 (CEST) MIME-Version: 1.0 Date: Fri, 16 Jun 2023 12:35:04 +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: "Laurenz Albe" Cc: pgsql-general@lists.postgresql.org In-Reply-To: <6ba275cd2d442a913a234564aeaec27311ec1d16.camel@cybertec.at> References: <6ba275cd2d442a913a234564aeaec27311ec1d16.camel@cybertec.at> <71943c04e05c3c13d5cd2b287909f351@weiller.eu> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 16. Juni 2023 14:13, "Laurenz Albe" schrieb: > On Fri, 2023-06-16 at 09:40 +0000, Brainmue wrote: >=20 >>=20I am currently looking for a solution similar to Oracle Listener. >=20 >=20Can you explain why? Perhaps there exists a good solution for the > underlying problem. >=20 >=20Yours, > Laurenz Albe Hello Laurenz, I can try. We want to minimise dependencies between the application and the associat= ed PostgreSQL DB. The idea is that the application gets its DB alias and this is then used = as a connection string. This way we can decide in the backend on which server the PostgreSQL DB i= s running. We can manage very flexible moves without informing the application or ev= en requiring changes from them. Of course, there would also be the solution of always assigning a certain= fixed port to each application, but we have a lot of network segmentatio= n with many firewalls in between. This would require a lot of organisational effort. That is the idea behind it. Regards, Michael