postgresql.conf

listen_addresses = '*'
port = 15432

ssl         = on
ssl_ciphers = 'HIGH:!aNULL:!MD5:!DHE'

shared_preload_libraries = 'pg_buffercache, pg_stat_statements'

pg_stat_statements.max           = 2500
pg_stat_statements.track         = all
pg_stat_statements.track_utility = on
pg_stat_statements.save          = off

authentication_timeout  = 30s
seq_page_cost           = 0.1
random_page_cost        = 2.0

log_destination             = 'syslog'
logging_collector           = on
log_directory               = 'pg_log'
log_filename                = 'postgresql-%a.log'
log_truncate_on_rotation    = on
log_rotation_age            = 1d
log_rotation_size           = 0
log_min_duration_statement  = 1000
log_checkpoints             = on
log_line_prefix             = 'user=%u,db=%d,app=%a,client=%h '
log_autovacuum_min_duration = 0

autovacuum_vacuum_scale_factor  = 0.05
autovacuum_analyze_scale_factor = 0.02

default_statistics_target  = 500

datestyle                  = 'iso, mdy'
lc_messages                = 'en_US.UTF-8'
lc_monetary                = 'en_US.UTF-8'
lc_numeric                 = 'en_US.UTF-8'
lc_time                    = 'en_US.UTF-8'
default_text_search_config = 'pg_catalog.english'

shared_buffers       = 2500MB
work_mem             = 10MB
maintenance_work_mem = 256MB
effective_cache_size = 5112MB

max_connections      = 1024

deadlock_timeout     = 1s

checkpoint_segments          = 32
checkpoint_completion_target = 0.8
checkpoint_warning           = 30s

archive_mode    = on

archive_command = '/usr/bin/rsync -e "ssh -c arcfour -o UserKnownHostsFile=/dev/null -o StrictHostKeyChecking=no" --quiet -a %p barman@barman1:/var/lib/barman/barmanbkups/main/incoming/%f'

random_page_cost = 1.1

wal_buffers          = -1
wal_keep_segments    = 70
wal_level            = hot_standby
max_wal_senders      = 10
hot_standby          = on

max_replication_slots = 4
wal_log_hints = on