From: Laurenz Albe <laurenz.albe@cybertec.at>
To: sacrophyte@gmail.com
To: pgsql-docs@lists.postgresql.org
Subject: Re: Step 8 does not perform as documented
Date: Thu, 04 Mar 2021 13:12:25 +0100
Message-ID: <b3d5af6694667f4893933fac317673654516517d.camel@cybertec.at> (raw)
In-Reply-To: <161479068834.1050.3165670090780890036@wrigleys.postgresql.org>
References: <161479068834.1050.3165670090780890036@wrigleys.postgresql.org>
On Wed, 2021-03-03 at 16:58 +0000, PG Doc comments form wrote:
> 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.
The log messages should tell you what is going on.
Perhaps you used a wrong time zone.
Yours,
Laurenz Albe
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: laurenz.albe@cybertec.at, sacrophyte@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Step 8 does not perform as documented
In-Reply-To: <b3d5af6694667f4893933fac317673654516517d.camel@cybertec.at>
* 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