MIME-Version: 1.0
From: Isaac Morland <isaac.morland@gmail.com>
Date: Tue, 26 Mar 2024 18:22:32 -0400
Message-ID: <CAMsGm5dbUPS+3NTJdVvnnvjdSDPk3f+ztxw+yXv56FJa5sdkEw@mail.gmail.com>
Subject: recovery.signal not being removed when recovery complete
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000af47b6061497baea"
Archived-At: <https://www.postgresql.org/message-id/CAMsGm5dbUPS%2B3NTJdVvnnvjdSDPk3f%2Bztxw%2ByXv56FJa5sdkEw%40mail.gmail.com>
Precedence: bulk

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

I use a script to restore a backup to create a testing copy of the
database. I set the following in postgresql.auto.conf:

recovery_target = 'immediate'
recovery_target_action = 'promote'

In the logs I get "recovery stopping after reaching consistency" then a
moment later "database system is ready to accept read-only connections",
then some entries about restoring log files, then "database system is ready
to accept connections".

I am able to make changes (e.g. CREATE TABLE), yet recovery.signal is still
present. My understanding is that recovery.signal should be removed when
recovery is finished (i.e., more or less when "database system is ready to
accept connections" is logged?), unless recovery_target_action is set to
'shutdown'.

Any ideas? Even just confirming/denying I understand the above correctly
would help.

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

<div dir=3D"ltr">I use a script to restore a backup to create a testing cop=
y of the database. I set the following in=C2=A0postgresql.auto.conf:<div><b=
r></div><div>recovery_target =3D &#39;immediate&#39;<br>recovery_target_act=
ion =3D &#39;promote&#39;<br></div><div><br></div><div>In the logs I get &q=
uot;recovery stopping after reaching consistency&quot; then a moment later =
&quot;database system is ready to accept read-only connections&quot;, then =
some entries about restoring log files, then &quot;database system is ready=
 to accept connections&quot;.</div><div><br></div><div>I am able to make ch=
anges (e.g. CREATE TABLE), yet recovery.signal is still present. My underst=
anding is that recovery.signal should be removed when recovery is finished =
(i.e., more or less when &quot;database system is ready to accept connectio=
ns&quot; is logged?), unless=C2=A0recovery_target_action is set to &#39;shu=
tdown&#39;.</div><div><br></div><div>Any ideas? Even just confirming/denyin=
g I understand the above correctly would help.</div></div>

--000000000000af47b6061497baea--