# Copied from: # https://github.com/jacobian/django-deployment-workshop # The OS-supplied postgresql.conf has every configuration directive known # to man, and is actually worth reading through carefully. For simplicity, # though, this is a stripped-down version with only the changes from the # defaults included. data_directory = '/var/lib/postgresql/9.6/main' hba_file = '/etc/postgresql/9.6/main/pg_hba.conf' ident_file = '/etc/postgresql/9.6/main/pg_ident.conf' external_pid_file = '/var/run/postgresql/9.6-main.pid' unix_socket_directories = '/var/run/postgresql' # # Connections and authentication # # Listen only on the internal IP interface. listen_addresses = 'localhost' port = 5432 # We'll have pgpool holding up a maximum of 40 connections per server, # so we need at least 80 connections. Add an additional 5 for superusers, # monitoring, etc. max_connections = 85 ssl = true ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem' ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key' shared_buffers = 24MB log_line_prefix = '%t ' log_timezone = 'GB' datestyle = 'iso, dmy' timezone = 'GB' lc_messages = 'en_GB.UTF-8' lc_monetary = 'en_GB.UTF-8' lc_numeric = 'en_GB.UTF-8' lc_time = 'en_GB.UTF-8' default_text_search_config = 'pg_catalog.english'