From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: sacrophyte@gmail.com
Subject: Step 8 does not perform as documented
Date: Wed, 03 Mar 2021 16:58:08 +0000
Message-ID: <161479068834.1050.3165670090780890036@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/continuous-archiving.html
Description:
Under the steps of Recovering with continuous logging, Step 8 says:
"Start the server. The server will go into recovery mode and proceed to read
through the archived WAL files it needs. Should the recovery be terminated
because of an external error, the server can simply be restarted and it will
continue recovery. Upon completion of the recovery process, the server will
remove recovery.signal (to prevent accidentally re-entering recovery mode
later) and then commence normal database operations."
The server went into recovery mode as expected. However, at the completion
of the recovery process, the server did *NOT* remove recovery.signal. Nor
did the server commend normal database operations. I manually shut down the
server, then removed recovery.signal and restarted the server, but then the
server recover _past_ my recovery_target_time. I am not sure why.
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: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, sacrophyte@gmail.com
Subject: Re: Step 8 does not perform as documented
In-Reply-To: <161479068834.1050.3165670090780890036@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox