pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedStep 8 does not perform as documented
3+ messages / 3 participants
[nested] [flat]
* Step 8 does not perform as documented
@ 2021-03-03 16:58 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: PG Doc comments form @ 2021-03-03 16:58 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: sacrophyte@gmail.com
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Step 8 does not perform as documented
@ 2021-03-04 12:12 Laurenz Albe <laurenz.albe@cybertec.at>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: Laurenz Albe @ 2021-03-04 12:12 UTC (permalink / raw)
To: sacrophyte@gmail.com; pgsql-docs@lists.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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Step 8 does not perform as documented
@ 2021-03-05 11:47 Charles Schultz <sacrophyte@gmail.com>
parent: Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 0 replies; 3+ messages in thread
From: Charles Schultz @ 2021-03-05 11:47 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; +Cc: pgsql-docs@lists.postgresql.org
Actually, I think it had more to do with the ambiguities around
recovery_target_action, which are documented elsewhere.
On Thu, Mar 4, 2021 at 6:12 AM Laurenz Albe <laurenz.albe@cybertec.at>
wrote:
> 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
>
>
--
Charles Schultz
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-03-05 11:47 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-03-03 16:58 Step 8 does not perform as documented PG Doc comments form <noreply@postgresql.org>
2021-03-04 12:12 ` Laurenz Albe <laurenz.albe@cybertec.at>
2021-03-05 11:47 ` Charles Schultz <sacrophyte@gmail.com>
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