Re: This is too implicit that recovery.signal will be removed

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: konkove(at)gmail(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: This is too implicit that recovery.signal will be removed
Date: 2023-10-05 15:31:23
Message-ID: CAKFQuwbtdJy0rHW+2AZdhLBcBLUr3wcYSD=6tWK=NAhknpac7Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Thu, Oct 5, 2023 at 8:15 AM PG Doc comments form <noreply(at)postgresql(dot)org>
wrote:

> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/16/runtime-config-wal.html
> Description:
>
> Hello.
> On the page
> https://www.postgresql.org/docs/current/runtime-config-wal.html
> Actual:
> >To start the server in targeted recovery mode, create a file called
> recovery.signal in the data directory. If both standby.signal and
> recovery.signal files are created, standby mode takes precedence. Targeted
> recovery mode ends when the archived WAL is fully replayed, or when
> recovery_target is reached. In this mode, the parameters from both this
> section and Section 20.5.6 will be used.
>
> Expected:
> >To start the server in targeted recovery mode, create a file called
> recovery.signal in the data directory. If both standby.signal and
> recovery.signal files are created, standby mode takes precedence. Targeted
> recovery mode ends and recovery.signal file is removed when the archived
> WAL
> is fully replayed, or when recovery_target is reached. In this mode, the
> parameters from both this section and Section 20.5.6 will be used. File
> 'recovery.signal' is not removed when `recovery_target_action` is
> *shutdown*.
>
>
Except that doesn't seem to be true since "pause" is the default action.

We probably should add instead:

Targeted recovery mode ends when the archived WAL is fully replayed, or
when recovery_target is reached.
The server is left in the state corresponding to the recovery_target_action
setting.

David J.

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message David G. Johnston 2023-10-05 15:50:16 Re: Unclear guarantees about sort order on https://www.postgresql.org/docs/current/queries-order.html
Previous Message PG Doc comments form 2023-10-05 15:14:32 It is not clear from documentation when and how I should restore base backup