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%20established%20successfully>:
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