MIME-Version: 1.0
References: <19488-d7ccfca2bf6b74b0@postgresql.org>
 <CAJTYsWUQBwCOQ=uGnLP7C2ofN6TqUpGeOHan2N99mza1DjybsQ@mail.gmail.com>
 <CAHGQGwG=F8_12nPKxUkYm-uS5QFJp+KF=3X5zM2vKP=0SKAeHw@mail.gmail.com>
 <CAPpHfdt_Fj73xYhKtEc66v7c_ZLaUSFqXfCWhRdp3tMX6ksMjQ@mail.gmail.com>
 <CAHGQGwHEVC1181tW78HuotgbF2jMF_59wzKrtS7hFYn_f9tuew@mail.gmail.com>
 <CAJTYsWXDoWuXCbgOYfTiBFTxg6-d+CX8urk0KswQX0Fm4JS+ag@mail.gmail.com>
 <CAJTYsWUOm7qCmguHJzus43YttCTmQzfcAoyfoY6pkaeqTnwE3Q@mail.gmail.com>
 <CAPpHfdszpu=qOtNBgeF=ijJLW3ODUA6YuJbKq6c0Do7R-CWXHg@mail.gmail.com>
In-Reply-To: 
 <CAPpHfdszpu=qOtNBgeF=ijJLW3ODUA6YuJbKq6c0Do7R-CWXHg@mail.gmail.com>
From: Ayush Tiwari <ayushtiwari.slg01@gmail.com>
Date: Thu, 21 May 2026 17:18:34 +0530
Message-ID: 
 <CAJTYsWXEpdWt57Vu13-5aEROVfq+G+zgAzZUwzAtFfYyfYDhHw@mail.gmail.com>
Subject: Re: BUG #19488: Standby connection fails after dropping on login
 event trigger enabled always
To: Alexander Korotkov <aekorotkov@gmail.com>
Cc: Fujii Masao <masao.fujii@gmail.com>, kyzevan23@mail.ru,
	pgsql-bugs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000a4b2c70652527ecc"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJTYsWXEpdWt57Vu13-5aEROVfq%2BG%2BzgAzZUwzAtFfYyfYDhHw%40mail.gmail.com>
Precedence: bulk

--000000000000a4b2c70652527ecc
Content-Type: text/plain; charset="UTF-8"

Hi,

On Thu, 21 May 2026 at 17:01, Alexander Korotkov <aekorotkov@gmail.com>
wrote:

>
> I suggest another approach.  Create a separate test database and apply
> event trigger on it.  wait_for_catchup() and others use 'postgres'
> database and wouldn't touch our test database.
> I also added check for successful clearance of the flag on both
> primary and standby.  One issue spotted there: in-place heap update
> doesn't issue a WAL flush.  But I think that's minor, WAL could be
> flushed by any subsequent operation.


I agree the approach you are suggesting is better.

Patch looks good to me!

Regards,
Ayush

--000000000000a4b2c70652527ecc
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Hi,</div><br><div class=3D"gmail_quote gm=
ail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, 21 May 2=
026 at 17:01, Alexander Korotkov &lt;<a href=3D"mailto:aekorotkov@gmail.com=
">aekorotkov@gmail.com</a>&gt; wrote:</div><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);=
padding-left:1ex">
<br>
I suggest another approach.=C2=A0 Create a separate test database and apply=
<br>
event trigger on it.=C2=A0 wait_for_catchup() and others use &#39;postgres&=
#39;<br>
database and wouldn&#39;t touch our test database.<br>
I also added check for successful clearance of the flag on both<br>
primary and standby.=C2=A0 One issue spotted there: in-place heap update<br=
>
doesn&#39;t issue a WAL flush.=C2=A0 But I think that&#39;s minor, WAL coul=
d be<br>
flushed by any subsequent operation.</blockquote><div><br></div><div>I agre=
e the approach you are suggesting is better.<br><br>Patch looks good to me!=
<br><br>Regards,<br>Ayush</div></div></div>

--000000000000a4b2c70652527ecc--