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
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