diff options
| author | Peter Eisentraut <peter@eisentraut.org> | 2019-02-04 09:28:17 +0100 |
|---|---|---|
| committer | Peter Eisentraut <peter@eisentraut.org> | 2019-02-07 08:34:48 +0100 |
| commit | 13b89f96d07ad3da67b57f66c134c3609bd3e98f (patch) | |
| tree | 20bfabe96e6c0b8149636271f41b1a35eb523bcc /src | |
| parent | cd5afd8175e256fa401cf440d06304df746abe62 (diff) | |
| download | postgresql-13b89f96d07ad3da67b57f66c134c3609bd3e98f.tar.gz postgresql-13b89f96d07ad3da67b57f66c134c3609bd3e98f.zip | |
Allow some recovery parameters to be changed with reload
Change
archive_cleanup_command
promote_trigger_file
recovery_end_command
recovery_min_apply_delay
from PGC_POSTMASTER to PGC_SIGHUP. This did not require any further
changes.
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Discussion: https://www.postgresql.org/message-id/flat/ca28011a-cfaa-565c-d622-c1907c33ecf7%402ndquadrant.com
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/utils/misc/guc.c | 8 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 4 |
2 files changed, 4 insertions, 8 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 8681ada33a4..ea5444c6f15 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -2047,7 +2047,7 @@ static struct config_int ConfigureNamesInt[] = }, { - {"recovery_min_apply_delay", PGC_POSTMASTER, REPLICATION_STANDBY, + {"recovery_min_apply_delay", PGC_SIGHUP, REPLICATION_STANDBY, gettext_noop("Sets the minimum delay for applying changes during recovery."), NULL, GUC_UNIT_MS @@ -3398,7 +3398,7 @@ static struct config_string ConfigureNamesString[] = }, { - {"archive_cleanup_command", PGC_POSTMASTER, WAL_ARCHIVE_RECOVERY, + {"archive_cleanup_command", PGC_SIGHUP, WAL_ARCHIVE_RECOVERY, gettext_noop("Sets the shell command that will be executed at every restart point."), NULL }, @@ -3408,7 +3408,7 @@ static struct config_string ConfigureNamesString[] = }, { - {"recovery_end_command", PGC_POSTMASTER, WAL_ARCHIVE_RECOVERY, + {"recovery_end_command", PGC_SIGHUP, WAL_ARCHIVE_RECOVERY, gettext_noop("Sets the shell command that will be executed once at the end of recovery."), NULL }, @@ -3474,7 +3474,7 @@ static struct config_string ConfigureNamesString[] = }, { - {"promote_trigger_file", PGC_POSTMASTER, REPLICATION_STANDBY, + {"promote_trigger_file", PGC_SIGHUP, REPLICATION_STANDBY, gettext_noop("Specifies a file name whose presence ends recovery in the standby."), NULL }, diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index c7f53470df4..ad6c436f93f 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -244,9 +244,7 @@ # e.g. 'cp /mnt/server/archivedir/%f %p' # (change requires restart) #archive_cleanup_command = '' # command to execute at every restartpoint - # (change requires restart) #recovery_end_command = '' # command to execute at completion of recovery - # (change requires restart) # - Recovery Target - @@ -310,7 +308,6 @@ #primary_slot_name = '' # replication slot on sending server # (change requires restart) #promote_trigger_file = '' # file name whose presence ends recovery - # (change requires restart) #hot_standby = on # "off" disallows queries during recovery # (change requires restart) #max_standby_archive_delay = 30s # max delay before canceling queries @@ -329,7 +326,6 @@ #wal_retrieve_retry_interval = 5s # time to wait before retrying to # retrieve WAL after a failed attempt #recovery_min_apply_delay = 0 # minimum delay for applying changes during recovery - # (change requires restart) # - Subscribers - |