diff options
| author | Michael Paquier <michael@paquier.xyz> | 2019-02-28 11:02:11 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2019-02-28 11:02:11 +0900 |
| commit | b3a156858ab03cb5f9c55dedcaf85a6249b3ec64 (patch) | |
| tree | 6f468c9f48b33a598f0fbf377052eb9f11d5959e | |
| parent | 87c346a35ee869e401e736163ec9d21632cc3b0d (diff) | |
| download | postgresql-b3a156858ab03cb5f9c55dedcaf85a6249b3ec64.tar.gz postgresql-b3a156858ab03cb5f9c55dedcaf85a6249b3ec64.zip | |
Improve documentation of data_sync_retry
Reflecting an updated parameter value requires a server restart, which
was not mentioned in the documentation and in postgresql.conf.sample.
Reported-by: Thomas Poty
Discussion: https://postgr.es/m/15659-0cd812f13027a2d8@postgresql.org
| -rw-r--r-- | doc/src/sgml/config.sgml | 3 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 4 |
2 files changed, 5 insertions, 2 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 1c3b7affa9f..6d42b7afe73 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -8791,7 +8791,8 @@ dynamic_library_path = 'C:\tools\postgresql;H:\my_project\lib;$libdir' <para> When set to off, which is the default, <productname>PostgreSQL</productname> will raise a PANIC-level error on failure to flush modified data files - to the filesystem. This causes the database server to crash. + to the filesystem. This causes the database server to crash. This + parameter can only be set at server start. </para> <para> On some operating systems, the status of data in the kernel's page diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 194f3120964..bd6ea65d0c8 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -719,7 +719,9 @@ #exit_on_error = off # terminate session on any error? #restart_after_crash = on # reinitialize after backend crash? -#data_sync_retry = off # retry or panic on failure to fsync data? +#data_sync_retry = off # retry or panic on failure to fsync + # data? + # (change requires restart) #------------------------------------------------------------------------------ |