Follow these steps to learn more about PostgreSQL settings:
- Execute the following query to obtain a list of settings that require a server restart and their current value:
SELECT name, setting
FROM pg_settings
WHERE context = 'postmaster';
- Execute this query for a list of only those settings that are not changed from the default and require restart:
SELECT name, setting, boot_val
FROM pg_settings
WHERE context = 'postmaster'
AND boot_val = setting;
- Execute the following query for a list of all settings and a translation of how the setting is managed:
SELECT name, CASE context WHEN 'postmaster' THEN 'REQUIRES RESTART' WHEN 'sighup' THEN 'Reload Config' WHEN 'backend' THEN 'Reload Config' WHEN 'superuser' THEN 'Reload ...
