Re: Allow some recovery parameters to be changed with reload

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2019-02-05T03:35:14Z
Lists: pgsql-hackers
On Mon, Feb 04, 2019 at 11:58:28AM +0100, Peter Eisentraut wrote:
> I think the recovery parameters
> 
>     archive_cleanup_command

Only triggered by the checkpointer.

>     promote_trigger_file
>     recovery_end_command
>     recovery_min_apply_delay

Only looked at by the startup process.

> can be changed from PGC_POSTMASTER to PGC_SIGHUP without any further
> complications (unlike for example primary_conninfo, which is being
> discussed elsewhere).

I agree that this subset is straight-forward and safe to switch.  The
documentation changes look right.
--
Michael

Commits

  1. Allow restore_command parameter to be changed with reload.

  2. Stamp 13.0.

  3. Allow some recovery parameters to be changed with reload