postgresql.conf

PostgreSQL Configuration Conf

 

On installation, the following changes are made to the postgresql.conf file:

1. Enable listening on all interfaces:

# - Connection Settings -
listen_addresses = '*'

2. The following are tuned relative to hardware:

max_connections

shared_buffers

effective_cache_size

work_mem

maintenance_work_mem

wal_buffers

min_wal_size

max_wal_size

checkpoint_completion_target

default_statistics_target

 

This constitutes a baseline tuning that will require updating once usage is established.

 

Next Up: End User Guid

Virtualmin End User Guide