listen_addresses                = 'localhost, @vpn_ipv4@'
port                            = 5432
max_connections                 = 128
superuser_reserved_connections  = 16
 
password_encryption             = scram-sha-256
db_user_namespace               = off
row_security                    = on
 
shared_buffers                  = 256MB
huge_pages                      = on
temp_buffers                    = 8MB
max_prepared_transactions       = 0
 
work_mem                        = 16MB
maintenance_work_mem            = 512MB
replacement_sort_tuples         = 150000
autovacuum_work_mem             = -1
max_stack_depth                 = 4MB
dynamic_shared_memory_type      = posix
 
log_destination                 = 'stderr'
logging_collector               = on
 
log_directory                   = 'log'
log_filename                    = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_file_mode                   = 0600
log_truncate_on_rotation        = off
log_rotation_age                = 1d
log_rotation_size               = 10MB
log_line_prefix                 = '%m %d %u [%p]'
 
datestyle                       = 'iso, mdy'
intervalstyle                   = 'postgres'
timezone_abbreviations          = 'Default'
 
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'