PostgreSQL High Availability Cookbook - Second 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 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 ...