blob: acf982c15459f28cb380780a1258dc79081d37d6 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
# 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)?
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.
|