From: legrand legrand <legrand_legrand@hotmail.com>
To: Pavel Luzanov <p.luzanov@postgrespro.ru>,
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject:
 =?Windows-1252?Q?Re=A0:_does_multi_host_connection_string_supports_login_?=
 =?Windows-1252?Q?event_trigger_exception?=
Thread-Topic:
 =?Windows-1252?Q?Re=A0:_does_multi_host_connection_string_supports_login_?=
 =?Windows-1252?Q?event_trigger_exception?=
Thread-Index: AQHb4U8pjD2NBGAXaUibpOX3MMvw2LQK51wAgACb2WU=
Date: Fri, 20 Jun 2025 05:28:07 +0000
Message-ID:
 <AS8PR08MB66320AF8510813B279C8D3C4907CA@AS8PR08MB6632.eurprd08.prod.outlook.com>
References:
 <AS8PR08MB6632193E0D8A5ED714026F84907DA@AS8PR08MB6632.eurprd08.prod.outlook.com>
 <1f740e0d-f58b-4492-85c4-bbfb330c9f89@postgrespro.ru>
In-Reply-To: <1f740e0d-f58b-4492-85c4-bbfb330c9f89@postgrespro.ru>
Accept-Language: fr-FR, en-US
Content-Language: fr-FR
x-ms-exchange-messagesentrepresentingtype: 1
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: AS8PR08MB6632:EE_|PA4PR08MB7644:EE_
x-ms-office365-filtering-correlation-id: e2a1f2fe-50c5-4f48-4203-08ddafbb3d02
x-microsoft-antispam:
 BCL:0;ARA:14566002|461199028|7092599006|21061999006|19110799006|8060799009|15030799003|8062599006|15080799009|440099028|3412199025|40105399003|102099032;
x-microsoft-antispam-message-info:
 =?Windows-1252?Q?tjDs4mP8sWc13OoNJiZtyZJ9A9cDfLAt+alvj8VG8o17rbxjF5W55CXi?=
 =?Windows-1252?Q?SbTfiD1MKFCDUORpV+I4AmULn9/TJeykJC4I1yCaXFTO4DqrPfZ052iP?=
 =?Windows-1252?Q?ZcbNQLDQA+KblPrER9LDdRpMMGwyeDk4DwIBW25jmqpAiSNSrTRvMdTg?=
 =?Windows-1252?Q?Hgn4+UU0RvRl22Gom7j+SNxmul4e9VBZ/Tm6K9wlflLdE2qpmezucXnP?=
 =?Windows-1252?Q?OFybJafqYV06VuEC/V/5QtFq2TnddS5hSKoVHJ8uwFxK/VIxYHRxbpfz?=
 =?Windows-1252?Q?Sg5MapWhhVqZuGxqnPIhkYOtZDrJat3FE/hrXPZCdRc1uR6okv+NatGY?=
 =?Windows-1252?Q?FwCFYtnTXipEgEq4WoHveGPG2Lxzv/X2ZRB7wdvSQRJjN+/kxBGt7yFv?=
 =?Windows-1252?Q?nDzEt5BldHVhmc1nqj59L9lBASlLPP5Vi7qSyzexiDzwnTMeehlxJpEj?=
 =?Windows-1252?Q?vDaykOGqWNpdrhc8VkLce2BI/kPOk0D9uLO74W6LzbG4jnVOOvjm2x3w?=
 =?Windows-1252?Q?pSdPa5XqsTkbmz6ta0Ibmi91W9EWtdn8Bd3jM4783Ceg1eP8Q9ThaXKd?=
 =?Windows-1252?Q?G8uZ153qhHlgOlLZ/3wyNj3ORaWfQF6NW4mS/TK881KgVcJCVYNQgPNc?=
 =?Windows-1252?Q?OA+c3PqLfBCfqlrp3MDsuc2phMoF13Iof6riMVmIgPFWSmCuHDG+5gff?=
 =?Windows-1252?Q?0LjsCIHz3SfQL6zOoa+s2Chkx5eNLGEEXiCXCeJl6oQjVC8CVyCTeOaW?=
 =?Windows-1252?Q?l9IXo3XsvYY3yxlgunOc5jazr+OlYbUVTsrGHuNnpirVsDif7pf4MNBt?=
 =?Windows-1252?Q?CffiJhycAP5dfm+40764dxI9rWgdwYetL2QyrxEswTECsvJR9i7HA85W?=
 =?Windows-1252?Q?zD50WPEiRwdxUJ0QBfHEdF1eSNnwl6fy10FOKk58k6sSP2iOTjztBFTs?=
 =?Windows-1252?Q?sW2wJ7m5eV0PmW0/1prGlrakbUf9z1VR9fE9/SlI3zBxpQE0J2Punoa5?=
 =?Windows-1252?Q?mnIb5AnTzQpoYXO+aXuEoLqXdtbHN8FSfnuA9AY4SEFDxYBKhlBn64Fl?=
 =?Windows-1252?Q?PPSHYBr6Iqr6mkKfF2QqJnk4cp5ivjxrTqv6MEzCU4ubuG0ywQLEQo8V?=
 =?Windows-1252?Q?aQCFz/GGmsYZstJSrOi1FR1gmOoSquCQeh/iR5O1lwi8Wuhhl2JPISsS?=
 =?Windows-1252?Q?JE3A4R8aDcg8jv6oDwh4i1E/PDb4L1HrdvTwaNflV2NfPGcAtBo84LBS?=
 =?Windows-1252?Q?HDlNs9r2wSV7jNP3s6uGoMOUHiO/wlB9IPkrih/b7AGUx73R+Gq+Ff0R?=
 =?Windows-1252?Q?7V+eUQ=3D=3D?=
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?Windows-1252?Q?CwfIZMk6IiEfdqZfqBfEeHpoqzy3xQwAsv16WPR5+GO49EOSdFa5IH9q?=
 =?Windows-1252?Q?uCo427pzEYpBks30bIsOwQn0WWZkRpX69uV0fJ4J3XCofuS2Rexf4/Wf?=
 =?Windows-1252?Q?54P0TRFmbkyhtBg2rVgv20dBsRyTd5Tkn7ZYwbUDqca5RBlZqQSF+m/X?=
 =?Windows-1252?Q?hJ22e/qruNWN0IVY1MqaN2o+c5NQHBBSSg9P9nqie2I5u92mF09fHw+n?=
 =?Windows-1252?Q?LRIo2cpmjZj/8a/EAlksV4sjJvnG+xQ757Z2t6vMqAGMS08est6P5NhI?=
 =?Windows-1252?Q?8nZ6pX82V6A8863oqJFZNjA3lNeyi/mms3pK5xQzbK7XPeZprNemC9+q?=
 =?Windows-1252?Q?bQCEqTZDz4Cx1jbUNyt1xz7hr9HWbW79iyqfoG+FzMOTfvFCebjmKR5I?=
 =?Windows-1252?Q?OgCyt/od7X8XQEviQiC9N4jVfy3oBE06wDXaPLjfYnSPNvnHgIFARK9o?=
 =?Windows-1252?Q?li5mrXvKyBUEEzi2Kfun2KdUvPd3qn5jBzR+1ITOxX6Q1ji7mc3TO5N7?=
 =?Windows-1252?Q?lrLCWsXPv1AYfG17T7CpZCgJOOwMVgp6Jbl+ss+D3A57tOtm9YOcb2+f?=
 =?Windows-1252?Q?SbEdIL17gRAjpD8z6QxVYvOtW2J/y9KnCKO0HZ7nb0SKVXhxNJY1PxCT?=
 =?Windows-1252?Q?reZf+Eft3DKb7ZoagAhOzhctFKnxxWT36RSR2Y5zNsvvCgx2DFK36zoz?=
 =?Windows-1252?Q?n9GC05V+lYSDPy+yC/0PPOWL0d7/Vei2HOdVyU8KWGJkwm1gRaZQ+YT8?=
 =?Windows-1252?Q?mJng+I5zma8Lur2UQTGSH20WD7BfVzMn7kw2CkQAlj3B4qvXnAdOLuZ7?=
 =?Windows-1252?Q?mDFWacX5SMaiYMIgQKyO7w7HZb9Wy26FQmDImdNiESPCVzr4Beb32nvz?=
 =?Windows-1252?Q?welE6az7nyz4USt2gcJMU2OWdf9yRWz+zFbT+xoaZBEgRPNd/5XceCQH?=
 =?Windows-1252?Q?+6KeUl/CU0lU+/QcKKH8Sz8YSyaJB3EANKOXvu8AcuzYVuxugF8CQLlk?=
 =?Windows-1252?Q?mZyN23iwQtHC+kb9KwEO8W02/fXR2JNhtkBe4bJMYJWBKBMEcx6C3JSM?=
 =?Windows-1252?Q?s3ZW4xP8dyhMrunsRpzcpiael+TfMtE2X9Hcv8RAp586SlqEvqWrZWG7?=
 =?Windows-1252?Q?NLQGMKC+hZxpYXEv85Ilhd6dSj8JSQvybCpCJ8fpZSNwYV18hYZpXQ9z?=
 =?Windows-1252?Q?rfEpvrkoNKC2oJwMksM+DlqY+4qbOu1zZwsBzuZfuKaBvoXoWOblXFki?=
 =?Windows-1252?Q?2qZ8z9sAIQad7faA4pWxp2uncD3OOx0O2hwRspe02zPHb9YlO9oJ6wGb?=
 =?Windows-1252?Q?vGvlVJ7B6XIujswlrLey+g2vpRyCV9B9XfhCKN2pjm7kswT+2NJbH3u2?=
 =?Windows-1252?Q?skvc9Rp8Mo4NM96kNgzDmrz7e3HOOHZkJkk=3D?=
Content-Type: multipart/alternative;
	boundary="_000_AS8PR08MB66320AF8510813B279C8D3C4907CAAS8PR08MB6632eurp_"
MIME-Version: 1.0
X-OriginatorOrg: sct-15-20-8534-20-msonline-outlook-c6e85.templateTenant
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: AS8PR08MB6632.eurprd08.prod.outlook.com
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: e2a1f2fe-50c5-4f48-4203-08ddafbb3d02
X-MS-Exchange-CrossTenant-originalarrivaltime: 20 Jun 2025 05:28:07.2673
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: PA4PR08MB7644
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/AS8PR08MB66320AF8510813B279C8D3C4907CA%40AS8PR08MB6632.eurprd08.prod.outlook.com>
Precedence: bulk

--_000_AS8PR08MB66320AF8510813B279C8D3C4907CAAS8PR08MB6632eurp_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable


Hi, Pavel !
Thank you for this fast and detailled answer !!

As LOGIN trigger is not working with multi host connections, I=92ll have to=
 find an other solution (maybe overloading pg_is_in_recovery() function)

Have a good day :0)
Regards
PAscal

--_000_AS8PR08MB66320AF8510813B279C8D3C4907CAAS8PR08MB6632eurp_
Content-Type: text/html; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DWindows-1=
252">
</head>
<body>
<div style=3D"font-family: inherit; font-size: inherit; color: inherit; bac=
kground-color: transparent;">
</div>
<div id=3D"divRplyFwdMsg" dir=3D"ltr"><font face=3D"Calibri, sans-serif" st=
yle=3D"font-size:11pt" color=3D"#000000"><br>
</font>
<div>&nbsp;</div>
</div>
<div>Hi, Pavel !<br>
</div>
<div>Thank you for this fast and detailled answer !!</div>
<div><br>
</div>
<div>As LOGIN trigger is not working with multi host connections, I=92ll ha=
ve to find an other solution (maybe overloading pg_is_in_recovery() functio=
n)</div>
<div><br>
</div>
<div>Have a good day :0)</div>
<div>Regards</div>
<div>PAscal</div>
</body>
</html>

--_000_AS8PR08MB66320AF8510813B279C8D3C4907CAAS8PR08MB6632eurp_--