Message-ID: <b3d5af6694667f4893933fac317673654516517d.camel@cybertec.at>
Subject: Re: Step 8 does not perform as documented
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: sacrophyte@gmail.com, pgsql-docs@lists.postgresql.org
Date: Thu, 04 Mar 2021 13:12:25 +0100
In-Reply-To: <161479068834.1050.3165670090780890036@wrigleys.postgresql.org>
References: <161479068834.1050.3165670090780890036@wrigleys.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) 
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/b3d5af6694667f4893933fac317673654516517d.camel%40cybertec.at>
Precedence: bulk

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