Pages

Tuesday, April 28, 2020

Query to find parameters which requires restart in postgresql

Ans:

select name,setting from pg_settings where context='postmaster';

e.g.,

postgres=#  select name,setting from pg_settings where context='postmaster';
                name                 |                 setting                 
-------------------------------------+-----------------------------------------
 allow_system_table_mods             | off
 archive_mode                        | off
 autovacuum_freeze_max_age           | 200000000
 autovacuum_max_workers              | 3
 autovacuum_multixact_freeze_max_age | 400000000
 bonjour                             | off

.....


No comments:

Post a Comment