data_directory = '/var/lib/postgresql/10/main' # use data in another directory
hba_file = '/etc/postgresql/10/main/pg_hba.conf' # host-based authentication file
ident_file = '/etc/postgresql/10/main/pg_ident.conf' # ident configuration file
external_pid_file = '/var/run/postgresql/10-main.pid' # write an extra PID file
listen_addresses = '*' # what IP address(es) to listen on;
port = 5432 # (change requires restart)
max_connections = 500 # (change requires restart)
unix_socket_directories = '/var/run/postgresql' # comma-separated list of directories
ssl = on
ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem'
ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key'
dynamic_shared_memory_type = posix # the default is the first option
shared_preload_libraries = 'pg_cron' # (change requires restart)
cron.database_name = 'NLP'
wal_level = logical # minimal, replica, or logical
archive_mode = on # enables archiving; off, on, or always
archive_command = 'exit 0;' # command to use to archive a logfile segment
hot_standby_feedback = on # send info from standby to prevent
client_min_messages = log # values in order of decreasing detail:
log_min_messages = log # values in order of decreasing detail:
log_min_error_statement = log # values in order of decreasing detail:
log_line_prefix = '%m [%p] %q%u@%d ' # special values:
log_timezone = 'localtime'
cluster_name = '10/main' # added to process titles if nonempty
stats_temp_directory = '/var/run/postgresql/10-main.pg_stat_tmp'
datestyle = 'iso, mdy'
timezone = 'localtime'
lc_messages = 'en_US.UTF-8' # locale for system error message
lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
lc_numeric = 'en_US.UTF-8' # locale for number formatting
lc_time = 'en_US.UTF-8' # locale for time formatting
default_text_search_config = 'pg_catalog.english'
include_dir = 'conf.d' # include files ending in '.conf' from
default_statistics_target = 50 # pgtune wizard 2018-04-26
maintenance_work_mem = 1GB # pgtune wizard 2018-04-26
constraint_exclusion = on # pgtune wizard 2018-04-26
checkpoint_completion_target = 0.9 # pgtune wizard 2018-04-26
effective_cache_size = 44GB # pgtune wizard 2018-04-26
work_mem = 64MB # pgtune wizard 2018-04-26
wal_buffers = 8MB # pgtune wizard 2018-04-26
shared_buffers = 15GB # pgtune wizard 2018-04-26