Downloads
Home   >   mailing lists

Re: does multi host connection string supports login event trigger exception - Mailing list pgsql-general

From Pavel Luzanov
Subject Re: does multi host connection string supports login event trigger exception
Date
Msg-id 1f740e0d-f58b-4492-85c4-bbfb330c9f89@postgrespro.ru
Whole thread Raw
In response to does multi host connection string supports login event trigger exception  (legrand legrand <legrand_legrand@hotmail.com>)
Responses Re : does multi host connection string supports login event trigger exception
List pgsql-general
Tree view
Hi, legrand!


On 19.06.2025 22:31, legrand legrand wrote:
P {margin-top:0;margin-bottom:0;}
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:
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

pgsql-general by date:

Previous
From: legrand legrand
Date:
Subject: does multi host connection string supports login event trigger exception
Next
From: legrand legrand
Date:
Subject: Re : does multi host connection string supports login event trigger exception