|
was size set. Seems I was not propagating the results through to the server.
[16:09 pg03 dvl ~] % sudo cat /usr/local/etc/postgresql.conf.d/postgresql.local.conf
listen_addresses = '10.55.0.34'
ssl = on
ssl_cert_file = '/usr/local/etc/ssl/pg03.int.unixathome.org.cer' # (change requires restart)
ssl_key_file = '/usr/local/etc/ssl/pg03.int.unixathome.org.key' # (change requires restart)
ssl_ca_file = '/usr/local/etc/ssl/ca.cer' # (change requires restart)
work_mem = 1MB # min 64kB
maintenance_work_mem = 1GB
max_wal_size = 16GB
min_wal_size = 80MB
checkpoint_completion_target = 0.7
client_min_messages = notice
log_min_messages = notice
log_min_error_statement = notice
log_checkpoints = on
log_connections = on
log_disconnections = on
log_duration = on
log_lock_waits = on
log_statement = 'all'
log_timezone = 'UTC'
#datestyle = 'iso, mdy'
timezone = 0
# added for three concurrent restores:
max_connections = 200
|