pg_settings.md

pg_settings.md

name	current_setting	source
application_name	pgAdmin III - Query Tool	client
archive_command	/var/lib/postgresql/walBackup/scripts/archiveWal.sh %p	configuration file
archive_mode	on	configuration file
auto_explain.log_format	json	configuration file
auto_explain.log_min_duration	1250ms	configuration file
auto_explain.log_verbose	on	configuration file
bytea_output	escape	session
checkpoint_completion_target	0.9	configuration file
client_encoding	UNICODE	session
client_min_messages	notice	session
cluster_name	9.5/main	configuration file
constraint_exclusion	on	configuration file
DateStyle	ISO, DMY	session
default_statistics_target	100	configuration file
default_text_search_config	pg_catalog.english	configuration file
dynamic_shared_memory_type	posix	configuration file
effective_cache_size	12GB	configuration file
hot_standby	on	configuration file
hot_standby_feedback	on	configuration file
lc_messages	en_GB.UTF-8	configuration file
lc_monetary	en_GB.UTF-8	configuration file
lc_numeric	en_GB.UTF-8	configuration file
lc_time	en_GB.UTF-8	configuration file
listen_addresses	*	configuration file
log_checkpoints	on	configuration file
log_line_prefix	%m [%p-%l] %q%u:%a@%d %h	configuration file
log_lock_waits	on	configuration file
log_min_duration_statement	1250ms	configuration file
log_timezone	GB	configuration file
maintenance_work_mem	1GB	configuration file
max_connections	1000	configuration file
max_stack_depth	2MB	environment variable
max_standby_streaming_delay	10min	configuration file
max_wal_senders	8	configuration file
max_wal_size	8GB	configuration file
min_wal_size	2GB	configuration file
port	5432	configuration file
shared_buffers	4GB	configuration file
ssl	on	configuration file
ssl_cert_file	/etc/ssl/certs/ssl-cert-snakeoil.pem	configuration file
ssl_key_file	/etc/ssl/private/ssl-cert-snakeoil.key	configuration file
synchronous_standby_names	pg001_replica	configuration file
TimeZone	GB	configuration file
track_commit_timestamp	on	configuration file
wal_buffers	16MB	configuration file
wal_compression	on	configuration file
wal_keep_segments	1536	configuration file
wal_level	hot_standby	configuration file
wal_log_hints	on	configuration file
work_mem	4MB	configuration file