Re: Step 8 does not perform as documented

From: Charles Schultz <sacrophyte(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Step 8 does not perform as documented
Date: 2021-03-05 11:47:25
Message-ID: CAPZQniXoZEqGZ_H6vrzbBdmQdSWFup9zxSChbGB1OoaAZ5=ytQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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(dot)albe(at)cybertec(dot)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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2021-03-06 23:19:06 make tutorial 13.2
Previous Message PG Doc comments form 2021-03-04 15:57:50 Jumbled words