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 1qABT8-0003M3-9B for pgsql-general@arkaria.postgresql.org; Fri, 16 Jun 2023 15:34:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qABT7-0003j9-0c for pgsql-general@arkaria.postgresql.org; Fri, 16 Jun 2023 15:34:33 +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 1qABT6-0003iz-KA for pgsql-general@lists.postgresql.org; Fri, 16 Jun 2023 15:34:32 +0000 Received: from mail-yw1-x1131.google.com ([2607:f8b0:4864:20::1131]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qABT3-002oa0-3A for pgsql-general@lists.postgresql.org; Fri, 16 Jun 2023 15:34:31 +0000 Received: by mail-yw1-x1131.google.com with SMTP id 00721157ae682-5700b37da3fso9866937b3.1 for ; Fri, 16 Jun 2023 08:34:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1686929667; x=1689521667; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=Pi9j1oya12HcGObskLl81kNtusnJSnsb6jDtMMjjkms=; b=nEu40gJcsBu1dhNngsM5LfOWjhm9dC16/Wl2U8lEKABJxY6unWQn9RiF/hq+zwql9u KhYkU8NIu0nAJxN8oKTTafYfbxDACPcajJG2D+XJmZS18fs++2+o4rYbBwXR3hPPma8/ 9p67vlmGVdu0zf7RldtdYqik4WxPw+5ESCo7nnLM1fuBamIHbrtMww1t39oCkoug0qRU 0/z6r13RK1eOrOn+q7O6urP+ypUUzEytV6GK5ExXj65QvQCYxhRBF6KWV8DE5OtUVJgs fiUZngxbXaj0Xr4M60GPjXbAV4UvcT+ENV8wjWEAtoci0wDTh1xOGPMCRsuCoPyO1lYT F8ZQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1686929667; x=1689521667; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=Pi9j1oya12HcGObskLl81kNtusnJSnsb6jDtMMjjkms=; b=gtWpgEydrBZ5vvahuCreaIbwuI6X6X2brkIDtXC9jKyWf6KR47GJrSWh3duF9O99UV YDYoP5ENS7ZT08shR/eBAWocXK/NHJzUy4OkrVlQqYj9qhnDo3CJ+mOtC/mFF3m9c7kF +do9lnzvmqRLchELVIbviIp6RJmzPZ7x/aJn2oKQiC0vufUdWEKDDuGQbdXlG5XPg3Ad 52U3mujddPMJa+jFvp2wqAYflEUUKshlIF2q58Uvx2YkPTwwGAGXy34l6fNyQjUj+uJB 5QgaVAvXtEUceTy/X0oMQcJwFKFjKpMmoGeoYcEjiptyp38cpxXBU4LnISiX4l7JpTh8 zZdw== X-Gm-Message-State: AC+VfDyUseFjOX5WZPDFnRy6EksxQO8TdXoyT+2roy9+6R07uCtO/I5y +sDqW7mM0cwYCxnGR+ywHqNmP5m3Ppk= X-Google-Smtp-Source: ACHHUZ4cu+8I7ZpSrVwsMZYoCDrV7wNT3se3QOXOLJtZZ+OYuOlubSrMo0U9hcpSmDx7GqNnO+iMBg== X-Received: by 2002:a81:d341:0:b0:561:2b03:1423 with SMTP id d1-20020a81d341000000b005612b031423mr2097277ywl.21.1686929666524; Fri, 16 Jun 2023 08:34:26 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:f889:4059:a055:b96e? ([2600:1700:bd2c:b810:f889:4059:a055:b96e]) by smtp.googlemail.com with ESMTPSA id t12-20020a81830c000000b0057008b83876sm1600387ywf.27.2023.06.16.08.34.26 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 16 Jun 2023 08:34:26 -0700 (PDT) Message-ID: Date: Fri, 16 Jun 2023 10:34:24 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: Question: Multiple pg clusters on one server can be reached with the standard port. Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <6ba275cd2d442a913a234564aeaec27311ec1d16.camel@cybertec.at> <71943c04e05c3c13d5cd2b287909f351@weiller.eu> <4d70ad6a5a73b9e9faaf8f2715cac862c86def3c.camel@cybertec.at> From: Ron In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 6/16/23 10:19, Laurenz Albe wrote: > On Fri, 2023-06-16 at 09:04 -0500, Ron wrote: >> On 6/16/23 07:50, Laurenz Albe wrote: >>> On Fri, 2023-06-16 at 12:35 +0000, Brainmue wrote: >>>> We want to minimise dependencies between the application and the associated 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 is running. >>> There is an existing solution for that: the libpq connection service file: >>> https://www.postgresql.org/docs/current/libpq-pgservice.html >> Do JDBC and ODBC recognize .pg_service.conf?  I know they don't recognize >> .pgpass. > JDBC doesn't, because it does not use libpq. > > ODBC can use both .pgpass and .pg_service.conf, since it uses libpq. All of the applications that we use are written in Java, so that wouldn't work. -- Born in Arizona, moved to Babylonia.