Step 8 does not perform as documented

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: sacrophyte(at)gmail(dot)com
Subject: Step 8 does not perform as documented
Date: 2021-03-03 16:58:08
Message-ID: 161479068834.1050.3165670090780890036@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Laurenz Albe 2021-03-04 12:12:25 Re: Step 8 does not perform as documented
Previous Message Georgios 2021-03-02 19:21:42 Re: GROUP BY DISTINCT