# 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/10/main'		# use data in another directory
hba_file = '/etc/postgresql/10/main/pg_hba.conf'	# host-based authentication file
ident_file = '/etc/postgresql/10/main/pg_ident.conf'	# ident configuration file
external_pid_file = '/var/run/postgresql/10-main.pid'			# write an extra PID file

# - Connection Settings -

# 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 = 100

unix_socket_directories = '/var/run/postgresql'	# comma-separated list of directories

ssl = on
ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem'
ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key'

# - Memory -

shared_buffers = 128MB

dynamic_shared_memory_type = posix	# the default is the first option

log_line_prefix = '%m [%p] %q%u@%d '
log_timezone = 'GB'

# - Process Title -
cluster_name = '10/main'

# - Query/Index Statistics Collector -

stats_temp_directory = '/var/run/postgresql/10-main.pg_stat_tmp'

# - Locale and Formatting -

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'

include_dir = 'conf.d'