diff options
| author | David Leutgeb <david@leutgeb.me> | 2022-07-07 10:45:03 +0200 |
|---|---|---|
| committer | David Leutgeb <david@leutgeb.me> | 2022-07-07 10:45:03 +0200 |
| commit | 3d5dc3cc70a37d24e1c1c8fc6ab3549f28a5e9c0 (patch) | |
| tree | 3734560304c93b239426ec47c96c506fce86c8a8 /change_settings.md | |
| parent | e5587043a9f758a48256ea6328b7cade46852d84 (diff) | |
| download | postgresql_hacks-3d5dc3cc70a37d24e1c1c8fc6ab3549f28a5e9c0.tar.gz postgresql_hacks-3d5dc3cc70a37d24e1c1c8fc6ab3549f28a5e9c0.zip | |
Changed change_settings.md
Diffstat (limited to 'change_settings.md')
| -rw-r--r-- | change_settings.md | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/change_settings.md b/change_settings.md index acf982c..55a9dac 100644 --- a/change_settings.md +++ b/change_settings.md @@ -1,10 +1,10 @@ -# How to reload config changes during the runtime (SIGHUP)? +## How to reload config changes during the runtime (SIGHUP)? ``` select pg_reload_conf(); ``` -# Does changing a config setting require a restart of postgresql or just a reload (SIGHUP)? +## 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. @@ -12,7 +12,7 @@ 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? +## Is a restart of postgresql required? ``` select pending_restart from pg_settings where name='max_wal_size'; |