FILE LOCATIONS

data_directory ='/pghs/pg${port}/data'

hba_file ='/pghs/pg${port}/data/pg_hba.conf'

- CONNECTIONS AND AUTHENTICATION -

port =${port}

listen_addresses ='0.0.0.0'max_connections = 500 superuser_reserved_connections = 10unix_socket_directories = '/tmp'unix_socket_permissions = 0700

- Security and Authentication

authentication_timeout = 1min

ssl = off

- TCP Keepalives -

tcp_keepalives_idle = 60

tcp_keepalives_interval = 10tcp_keepalives_count = 10

- Memory -

shared_buffers = 2048MB

temp_buffers = 8MB work_mem = 8MB maintenance_work_mem = 256MB max_stack_depth = 8192kB

- Kernel Resource Usage -

shared_preload_libraries = 'repmgr_funcs,pg_stat_statements,auto_explain'

- Background Writer -

bgwriter_delay = 200ms

WRITE AHEAD log

wal_level = hot_standby

fsync = onsynchronous_commit = localwal_buffers = 16MB

- Checkpoints -

checkpoint_segments = 32

- Archiving -

archive_mode = on

archive_command = 'test ! -f /pghs/pgbackup/pgbk${port}/archlog/%f && cp %p /pghs/pgbackup/pgbk${port}/archlog/%f'

REPLICATION

max_wal_senders = 5

wal_keep_segments = 128hot_standby = on

ERROR REPORTING AND LOGGING

log_destination = 'stderr,csvlog'

logging_collector = onlog_directory = '/pghs/pg${port}/data/pg_log'log_filename='postgresql-%d.log'log_truncate_on_rotation = onlog_line_prefix='%t:%r:%u@%d:[%p]: 'log_statement = 'ddl' log_checkpoints = onlog_connections = onlog_min_duration_statement = 60000 log_lock_waits = on

Locale and Formatting

datestyle = 'iso, mdy'

timezone = 'PRC'log_timezone = 'Asia/Hong_Kong'

- pg_stat_statements auto_explain -

pg_stat_statements.max = 10000

pg_stat_statements.track = allpg_stat_statements.track_utility = truepg_stat_statements.save = trueauto_explain.log_min_duration = 60s