aboutsummaryrefslogtreecommitdiff
path: root/files/var/db/postgres/data16/postgresql.conf.postgresql_server
blob: e95104f46fbb658b4514e6d5d2c3539f9ba23426 (plain) (blame)
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
35
36
37
38
39
40
41
42
43
listen_addresses = '*'
max_connections = ${postgres_max_connections}

krb_server_keyfile = 'FILE:${postgres_keytab}'
krb_caseins_users = on

ssl = on
ssl_ca_file = '${ca_cert}'
ssl_cert_file = '${postgres_tls_cert}'
ssl_key_file = '${postgres_tls_key}'
ssl_min_protocol_version = 'TLSv1.3'

shared_buffers = '${postgres_shared_buffers}B'
temp_buffers = '${postgres_temp_buffers}B'
work_mem = '${postgres_work_mem}B'
maintenance_work_mem = '${postgres_maintenance_work_mem}B'
dynamic_shared_memory_type = posix

wal_sync_method = fdatasync
full_page_writes = off
wal_compression = off
wal_init_zero = off
wal_recycle = off
max_wal_size = 1GB
min_wal_size = 80MB

effective_cache_size = '${postgres_effective_cache_size}B'

log_destination = 'syslog'
syslog_sequence_numbers = off

log_min_messages = info
log_min_error_statement = warning
log_line_prefix = '[%p] %q%u@%d '
log_timezone = 'US/Eastern'

datestyle = 'iso, mdy'
timezone = 'US/Eastern'
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'