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 1qABF7-0002eJ-HV for pgsql-general@arkaria.postgresql.org; Fri, 16 Jun 2023 15:20:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qABF6-0002Xl-Gf for pgsql-general@arkaria.postgresql.org; Fri, 16 Jun 2023 15:20:04 +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 1qABF6-0002Xc-69 for pgsql-general@lists.postgresql.org; Fri, 16 Jun 2023 15:20:04 +0000 Received: from mail-ej1-x635.google.com ([2a00:1450:4864:20::635]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qABF0-002Y72-Eb for pgsql-general@lists.postgresql.org; Fri, 16 Jun 2023 15:19:59 +0000 Received: by mail-ej1-x635.google.com with SMTP id a640c23a62f3a-977ed383b8aso120462566b.3 for ; Fri, 16 Jun 2023 08:19:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20221208.gappssmtp.com; s=20221208; t=1686928793; x=1689520793; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=syM2gZiwFTpwshwUIEV9X5Qklgx0e9zAnwSnahLC7gY=; b=RBMnMWZeQT1VwyqXOdwEqVHvrIcEAeFFMtT9P/gfKbYQaEJsNzSo0pLxwUu164mySw p91CUEgld3j7rycQ4Mt686qThnetLLKb/GKYaWLlia5fO6xnPOIYI3ezHXBBY31HTfzO rv05JcHqF37ZexyrDa8PLxPBm0o3W7HVTv2tD+YhM/zP7zHcaH+V3ZqNa/wdlrU/0LRC nhYkw7eu42r4lvJMfO4+5bYhTi7pvxkqt8XeAVowOCq9TKHDndXRtYl+42DceD2Fowe+ zxlctMmttA0wNr3IeBssKdTG+Tp7RYKMXfVbdXS/R07qqTRiosHuux+v3DORKFOLh/4F gTgw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1686928793; x=1689520793; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=syM2gZiwFTpwshwUIEV9X5Qklgx0e9zAnwSnahLC7gY=; b=BJEXKK/1YD85ZHtIQg56+7KbQcvQtrCldybAY1EXWO4NZD0e9718SQ1uQbVaLar2Q8 GDMc3EKtEOiK4y+hdt4ocfi5xIN0tuLnrrN2gK4a03QuHQM0Nj01X2ZBU+kvlMNF9JMF ZnTgiC09jSZwWZvJGpvAKgUs+7XzKqY7EO8LW1BZSHmE6rS5CtFCxbz3frTH7tB31Oia pueoCa4n+ngbV1MqgbJLUZ/d4kILyb5GgerpPYYnlsT4/VoAg8jSUF/oRFwfRs+RCcc5 xPpFNDSetiw3Z5J9HdU4shlt0o2+APhrRBJRzg1w6IN4Nmf+1VmZZnlrMjAnmtC3hqoQ c9fw== X-Gm-Message-State: AC+VfDxL23+dAs74+teZtuO5rSoQP0m9afJALWe84JoDrRWxhLTGuzZ4 0XWNloLLyNRFpu2e5CSSsSTh3yRRZ1nOTPPkGgQ= X-Google-Smtp-Source: ACHHUZ6rl+Vsr93eYKyDp+GTnOCTx0Tt+u441bhpntPc99F3VvonFbp42bzgyfQxMdHp0d9TLKWV8A== X-Received: by 2002:a17:907:9284:b0:974:1ef7:1e88 with SMTP id bw4-20020a170907928400b009741ef71e88mr1927733ejc.13.1686928793067; Fri, 16 Jun 2023 08:19:53 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:b870:ac22:aff8:c893:7f9a]) by smtp.gmail.com with ESMTPSA id a21-20020a1709066d5500b00978897577c6sm10779619ejt.44.2023.06.16.08.19.52 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 16 Jun 2023 08:19:52 -0700 (PDT) Message-ID: Subject: Re: Question: Multiple pg clusters on one server can be reached with the standard port. From: Laurenz Albe To: Ron , pgsql-general@lists.postgresql.org Date: Fri, 16 Jun 2023 17:19:51 +0200 In-Reply-To: References: <6ba275cd2d442a913a234564aeaec27311ec1d16.camel@cybertec.at> <71943c04e05c3c13d5cd2b287909f351@weiller.eu> <4d70ad6a5a73b9e9faaf8f2715cac862c86def3c.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 asso= ciated PostgreSQL DB. > > > The idea is that the application gets its DB alias and this is then u= sed 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 fi= le: > > https://www.postgresql.org/docs/current/libpq-pgservice.html >=20 > Do JDBC and ODBC recognize .pg_service.conf?=C2=A0 I know they don't reco= gnize=20 > .pgpass. JDBC doesn't, because it does not use libpq. ODBC can use both .pgpass and .pg_service.conf, since it uses libpq. Yours, Laurenz Albe