pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedThis is too implicit that recovery.signal will be removed
3+ messages / 3 participants
[nested] [flat]
* This is too implicit that recovery.signal will be removed
@ 2023-10-05 14:05 PG Doc comments form <noreply@postgresql.org>
2023-10-05 14:52 ` Re: This is too implicit that recovery.signal will be removed Eugen Konkov <konkove@gmail.com>
2023-10-05 15:31 ` Re: This is too implicit that recovery.signal will be removed David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: PG Doc comments form @ 2023-10-05 14:05 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: konkove@gmail.com
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*.
Overall I did not find page where I can read about all types of *.signal
files and how to deal with them.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: This is too implicit that recovery.signal will be removed
2023-10-05 14:05 This is too implicit that recovery.signal will be removed PG Doc comments form <noreply@postgresql.org>
@ 2023-10-05 14:52 ` Eugen Konkov <konkove@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Eugen Konkov @ 2023-10-05 14:52 UTC (permalink / raw)
To: konkove@gmail.com; pgsql-docs@lists.postgresql.org
Only here I found explicit mention that recovery.signal will be
removed: https://www.postgresql.org/docs/16/continuous-archiving.html#BACKUP-PITR-RECOVERY
see p8.
On Thu, Oct 5, 2023 at 10:06 AM PG Doc comments form
<noreply@postgresql.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*.
>
> Overall I did not find page where I can read about all types of *.signal
> files and how to deal with them.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: This is too implicit that recovery.signal will be removed
2023-10-05 14:05 This is too implicit that recovery.signal will be removed PG Doc comments form <noreply@postgresql.org>
@ 2023-10-05 15:31 ` David G. Johnston <david.g.johnston@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: David G. Johnston @ 2023-10-05 15:31 UTC (permalink / raw)
To: konkove@gmail.com; pgsql-docs@lists.postgresql.org
On Thu, Oct 5, 2023 at 8:15 AM PG Doc comments form <noreply@postgresql.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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-10-05 15:31 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-05 14:05 This is too implicit that recovery.signal will be removed PG Doc comments form <noreply@postgresql.org>
2023-10-05 14:52 ` Eugen Konkov <konkove@gmail.com>
2023-10-05 15:31 ` David G. Johnston <david.g.johnston@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