max_connections = 50                    # (change requires restart)
superuser_reserved_connections = 5      # (change requires restart)
ssl = on                                # (change requires restart)
ssl_ciphers = 'ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:DHE-DSS-AES256-GCM-SHA384:DHE-RSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:DHE-RSA-AES128-SHA256:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!3DES:!MD5:!PSK' # allowed SSL ciphers
ssl_prefer_server_ciphers = on          # (change requires restart)
#ssl_ecdh_curve = 'prime256v1'          # (change requires restart)
ssl_cert_file = '/edodata/pgsql/data/ssl/postgres.pem'       # (change requires restart)
ssl_key_file = '/edodata/pgsql/data/ssl/postgres.key'# (change requires restart)
ssl_ca_file = '/etc/ssl/certs/ca-bundle.crt'              # (change requires restart)
shared_buffers = 128MB                  # min 128kB
huge_pages = try                        # on, off, or try
temp_buffers = 8MB                      # min 800kB
work_mem = 64MB                                 # min 64kB
maintenance_work_mem = 128MB            # min 1MB
dynamic_shared_memory_type = posix      # the default is the first option
effective_io_concurrency = 200          # 1-1000; 0 disables prefetching
max_worker_processes = 8                # (change requires restart)
max_parallel_workers_per_gather = 4     # taken from max_worker_processes
synchronous_commit = off                # synchronization level;
wal_buffers = 16MB                      # min 32kB, -1 sets based on shared_buffers
max_wal_size = 2GB
min_wal_size = 1GB
checkpoint_completion_target = 0.7      # checkpoint target duration, 0.0 - 1.0
track_commit_timestamp = on     # collect timestamp of transaction commit
synchronous_standby_names = 'walreceiver'       # standby servers that provide sync rep
random_page_cost = 1.1                  # same scale as above
effective_cache_size = 128MB
default_statistics_target = 100 # range 1-10000
log_destination = 'csvlog'              # Valid values are combinations of
log_file_mode = 0640                    # creation mode for log files,
client_min_messages = notice            # values in order of decreasing detail:
log_min_messages = warning              # values in order of decreasing detail:
log_min_error_statement = error # values in order of decreasing detail:
log_error_verbosity = default           # terse, default, or verbose messages
log_replication_commands = off
log_temp_files = 0                      # log temporary files equal or larger
log_timezone = 'Australia/NSW'
autovacuum = on                 # Enable autovacuum subprocess?  'on'
autovacuum_max_workers = 3              # max number of autovacuum subprocesses
datestyle = 'iso, dmy'
timezone = 'Australia/NSW'
lc_messages = 'en_AU.UTF-8'                     # locale for system error message
lc_monetary = 'en_AU.UTF-8'                     # locale for monetary formatting
lc_numeric = 'en_AU.UTF-8'                      # locale for number formatting
lc_time = 'en_AU.UTF-8'                         # locale for time formatting
default_text_search_config = 'pg_catalog.english'

archive_command = 'cp "%p" "/edodbtranslogs/pgsql/%f"'
log_directory = '/edologs/pgsql'

# additional_config generated by postgresql_ha_conf resource
#
wal_keep_segments = 10
listen_addresses = '*'
max_wal_senders = 10
max_replication_slots = 12
wal_level = 'replica'
hot_standby = on
archive_mode = on
wal_log_hints = on
logging_collector = on
log_filename = 'postgresql.log'
log_line_prefix = '%m [%p] %q%u@%d '
log_checkpoints = on
log_connections = off
log_disconnections = off
log_lock_waits = on
log_duration = on
log_statement = 'none'
log_min_duration_statement = 5000
log_rotation_age = 0
log_rotation_size = 0