Ambiguity in restore_command for recovery.conf

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: cjames(at)emolecules(dot)com
Subject: Ambiguity in restore_command for recovery.conf
Date: 2018-09-18 16:10:17
Message-ID: 153728701749.28483.6427522510493541629@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/10/static/archive-recovery-settings.html
Description:

Documentation for restore_command in recovery.conf only says, "This
parameter is required for archive recovery, but optional for streaming
replication," but it doesn't say specifically when the restore_command
string will be used and why. My guess is that as long as the WAL files are
still available on the master (primary) host, the recovery will fetch them
via the replication slot, but if a WAL is missing on the primary, only then
will the restore_command be used. But this isn't explicitly stated. It could
be that the restore_command is always used, even if the WAL file is still
available on the primary.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2018-09-18 22:56:10 Punctuation error
Previous Message Adrien NAYRAT 2018-09-18 10:32:54 Mention FK creation take ShareRowExclusiveLock on referenced table