public inbox for [email protected]  
help / color / mirror / Atom feed
From: Pavel Luzanov <[email protected]>
To: legrand legrand <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: does multi host connection string supports login event trigger exception
Date: Thu, 19 Jun 2025 23:01:48 +0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <AS8PR08MB6632193E0D8A5ED714026F84907DA@AS8PR08MB6632.eurprd08.prod.outlook.com>
References: <AS8PR08MB6632193E0D8A5ED714026F84907DA@AS8PR08MB6632.eurprd08.prod.outlook.com>

Hi, legrand!


On 19.06.2025 22:31, legrand legrand wrote:
> I'm trying to build a login event trigger in conjonction with a multi 
> host connectio string
> to manager instances roles in a logical replication cluster.

According to docs 
<https://www.postgresql.org/docs/current/libpq-connect.html#:~:text=If%20a%20connection%20is%20establ...;:
If a connection is established successfully, but authentication fails, 
the remaining hosts in the list are not tried.

So, I think that this is impossible to use multiple hosts feature of 
libpq with on login trigger to skip some host.

-- 
Pavel Luzanov
Postgres Professional:https://postgrespro.com


reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: does multi host connection string supports login event trigger exception
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox