Software Público Brasileiro

listen_addresses = 'localhost,<%= node['peers']['database'] %>'

<% ram = `awk '{ if ($1 == "MemTotal:") {print($2) } }' /proc/meminfo`.to_i %>

#######################################################################
# performance optimization settings
#######################################################################
shared_buffers = <%= (0.1 * ram).to_i %>kB        # 10% of RAM for shared buffers
effective_cache_size = <%= (0.8 * ram).to_i %>kB  # 80% of RAM for cache

#######################################################################
# other settings
#######################################################################
max_connections = 500                             # (change requires restart)
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'
log_destination = 'syslog'                        # Send logs to syslog server
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'