Step 8 does not perform as documented
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.
Re: Step 8 does not perform as documented
On Wed, 2021-03-03 at 16:58 +, 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
Jumbled words
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createrole.html Description: "modified by later ALTER ROLE" to be changed to "modified later by ALTER ROLE".
