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 /doc/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 'doc/src')
-rw-r--r-- | doc/src/sgml/config.sgml | 21 |
1 files changed, 17 insertions, 4 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 9b7a7388d5a..7e208a4b812 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -3081,8 +3081,7 @@ include_dir 'conf.d' <para> This section describes the settings that apply only for the duration of the recovery. They must be reset for any subsequent recovery you wish to - perform. They can only be set at server start and cannot be changed once - recovery has begun. + perform. </para> <para> @@ -3161,6 +3160,10 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows database server shutdown) or an error by the shell (such as command not found), then recovery will abort and the server will not start up. </para> + + <para> + This parameter can only be set at server start. + </para> </listitem> </varlistentry> @@ -3202,6 +3205,10 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows terminated by a signal or an error by the shell (such as command not found), a fatal error will be raised. </para> + <para> + This parameter can only be set in the <filename>postgresql.conf</filename> + file or on the server command line. + </para> </listitem> </varlistentry> @@ -3227,6 +3234,10 @@ restore_command = 'copy "C:\\server\\archivedir\\%f" "%p"' # Windows signal or an error by the shell (such as command not found), the database will not proceed with startup. </para> + <para> + This parameter can only be set in the <filename>postgresql.conf</filename> + file or on the server command line. + </para> </listitem> </varlistentry> @@ -3863,7 +3874,8 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class=" standby. Even if this value is not set, you can still promote the standby using <command>pg_ctl promote</command> or calling <function>pg_promote</function>. - This parameter can only be set at server start. + This parameter can only be set in the <filename>postgresql.conf</filename> + file or on the server command line. </para> </listitem> </varlistentry> @@ -4117,7 +4129,8 @@ ANY <replaceable class="parameter">num_sync</replaceable> ( <replaceable class=" </warning> </para> <para> - This parameter can only be set at server start. + This parameter can only be set in the <filename>postgresql.conf</filename> + file or on the server command line. </para> </listitem> </varlistentry> |