How to check configuration applied or not in PostgreSQL
postgres=# select * from pg_file_settings;
sourcefile | sourceline | seqno | name | setting | applied | error
-------------------------------------------------------+------------+-------+----------------------------+----------------------------+---------+-------
D:/Program Files/PostgreSQL/data/postgresql.conf | 60 | 1 | listen_addresses | * | t |
D:/Program Files/PostgreSQL/data/postgresql.conf | 64 | 2 | port | 5432 | t |
D:/Program Files/PostgreSQL/data/postgresql.conf | 65 | 3 | max_connections | 100 | t |
D:/Program Files/PostgreSQL/data/postgresql.conf | 130 | 4 | shared_buffers | 128MB | t |
D:/Program Files/PostgreSQL/data/postgresql.conf | 153 | 5 | dynamic_shared_memory_type | windows | t |
D:/Program Files/PostgreSQL/data/postgresql.conf | 247 | 6 | max_wal_size | 1GB | t |
D:/Program Files/PostgreSQL/data/postgresql.conf | 248 | 7 | min_wal_size | 80MB | t |
D:/Program Files/PostgreSQL/data/postgresql.conf | 450 | 8 | log_destination | stderr | t |
D:/Program Files/PostgreSQL/data/postgresql.conf | 457 | 9 | logging_collector | on | t |
D:/Program Files/PostgreSQL/data/postgresql.conf | 467 | 10 | log_file_mode | 0640 | t |
D:/Program Files/PostgreSQL/data/postgresql.conf | 603 | 11 | log_timezone | Asia/Calcutta | t |
D:/Program Files/PostgreSQL/data/postgresql.conf | 715 | 12 | datestyle | iso, mdy | t |
| t |
(19 rows)
Comments
Post a Comment