data_directory = '/data/postgres/data/'
listen_addresses = '*'
port = 5432
max_connections = 1024
ssl = off
shared_buffers = 16GB
work_mem = 8MB
maintenance_work_mem = 1GB
shared_preload_libraries = 'pg_stat_statements,pg_partman_bgw'
pg_stat_statements.track = all
wal_level = logical
checkpoint_timeout = 15min
max_wal_size = 1GB
min_wal_size = 80MB
checkpoint_completion_target = 0.7
archive_mode = on
archive_command = '/bin/true'
max_wal_senders = 64
wal_keep_segments = 100
max_replication_slots = 20
hot_standby = on
hot_standby_feedback = on
log_destination = 'stderr'
logging_collector = on
log_directory = 'pg_log'
log_file_mode = 0600
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_truncate_on_rotation = on
log_rotation_age = 1d
log_rotation_size = 50MB
log_min_duration_statement = 100
log_checkpoints = on
log_line_prefix = '%t [%p] %q%u@%d %h '
log_lock_waits = on
log_statement = 'none'
log_timezone = 'Asia/Jakarta'
timezone = 'Asia/Jakarta'
pg_partman_bgw.interval = 3600
pg_partman_bgw.dbname = 'dborder'