pgdata# SELECT name, setting FROM pg_settings WHERE source != 'default'; name | setting ----------------------------+--------------------------------------------------- ------- application_name | psql archive_command | rsync -a %p postgres@standby:/home/postgres/wal_archive/%f archive_mode | on checkpoint_segments | 30 client_encoding | UTF8 config_file | /home/postgres/pgdata/postgresql.conf data_directory | /home/postgres/pgdata DateStyle | ISO, MDY default_text_search_config | pg_catalog.english effective_cache_size | 49152 fsync | on hba_file | /home/postgres/pgdata/pg_hba.conf hot_standby | on ident_file | /home/postgres/pgdata/pg_ident.conf lc_collate | en_US.UTF-8 lc_ctype | en_US.UTF-8 lc_messages | en_US.UTF-8 lc_monetary | en_US.UTF-8 lc_numeric | en_US.UTF-8 lc_time | en_US.UTF-8 listen_addresses | * log_line_prefix | %t log_min_duration_statement | 1000 log_timezone | America/New_York logging_collector | on maintenance_work_mem | 65536 max_connections | 15 max_stack_depth | 2048 max_wal_senders | 2 server_encoding | UTF8 shared_buffers | 16384 synchronous_commit | off TimeZone | America/New_York transaction_deferrable | off transaction_isolation | read committed transaction_read_only | off wal_buffers | 512 wal_keep_segments | 32 wal_level | hot_standby work_mem | 24576 (40 rows)