diff options
Diffstat (limited to 'change_settings.md')
| -rw-r--r-- | change_settings.md | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/change_settings.md b/change_settings.md new file mode 100644 index 0000000..c227654 --- /dev/null +++ b/change_settings.md @@ -0,0 +1,15 @@ +# Does changing a config setting require a restart of postgresql or just a reload (SIGHUP)? + +This can be archived by simply selecting the setting from pg_settings. + +``` +select context from pg_settings where name='max_wal_size'; +``` + +# Is a restart of postgresql required? + +``` +select pending_restart from pg_settings where name='max_wal_size'; +``` + +This will tell you if a restart is pending for a setting. |