PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

Follow these steps to learn more about PostgreSQL settings:

1. 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'; 

2. 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; 

3. Execute the following query for a list of all the settings and a translation of how each setting is managed:

SELECT name, CASE context WHEN 'postmaster' THEN 'RESTART' WHEN 'sighup' THEN 'Reload' WHEN 'backend' THEN 'Reload' WHEN 'superuser' THEN 'Reload / Superuser SET' ...