public inbox for [email protected]
help / color / mirror / Atom feedFrom: Isaac Morland <[email protected]>
To: [email protected] <[email protected]>
Subject: recovery.signal not being removed when recovery complete
Date: Tue, 26 Mar 2024 18:22:32 -0400
Message-ID: <CAMsGm5dbUPS+3NTJdVvnnvjdSDPk3f+ztxw+yXv56FJa5sdkEw@mail.gmail.com> (raw)
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.
view thread (2+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: recovery.signal not being removed when recovery complete
In-Reply-To: <CAMsGm5dbUPS+3NTJdVvnnvjdSDPk3f+ztxw+yXv56FJa5sdkEw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox