aboutsummaryrefslogtreecommitdiffstats
path: root/roles/postgresql_server/templates/var/lib/pgsql/data/postgresql.conf.j2
blob: 07d198e8504b5713a386f35b68850b7fc55033d9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
listen_addresses = '*'
max_connections = {{ postgresql_max_connections }}

ssl = on
ssl_cert_file = '{{ postgresql_certificate_path }}'
ssl_key_file = '{{ postgresql_certificate_key_path }}'
ssl_dh_params_file = '{{ postgresql_dhparams_path }}'
ssl_ciphers = '{{ postgresql_ssl_ciphers }}'

password_encryption = scram-sha-256

krb_caseins_users = on

shared_buffers = {{ postgresql_shared_buffers_mb }}MB
dynamic_shared_memory_type = posix	# the default is the first option

log_destination = 'stderr'
logging_collector = off
log_min_messages = info
log_min_error_statement = warning
log_connections = off
log_disconnections = off
log_line_prefix = '%q%u@%d '
log_timezone = '{{ postgresql_timezone }}'

datestyle = 'iso, mdy'
timezone = '{{ postgresql_timezone }}'

lc_messages = 'en_US.UTF-8'
lc_monetary = 'en_US.UTF-8'
lc_numeric = 'en_US.UTF-8'
lc_time = 'en_US.UTF-8'

default_text_search_config = 'pg_catalog.english'