postgresql.conf.erb
1.08 KB
listen_addresses = 'localhost,<%= node['peers']['database'] %>'
# TODO optimize these settings
max_connections = 100 # (change requires restart)
shared_buffers = 32MB # min 128kB
logging_collector = on # Enable capturing of stderr and csvlog
log_filename = 'postgresql-%a.log' # log file name pattern,
log_truncate_on_rotation = on # If on, an existing log file with the
log_rotation_age = 1d # Automatic rotation of logfiles will
log_rotation_size = 0 # Automatic rotation of logfiles will
log_timezone = 'UTC'
datestyle = 'iso, mdy'
timezone = 'UTC'
lc_messages = 'en_US.UTF-8' # locale for system error message
lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
lc_numeric = 'en_US.UTF-8' # locale for number formatting
lc_time = 'en_US.UTF-8' # locale for time formatting
default_text_search_config = 'pg_catalog.english'