2023-12-29 18:07:08 +00:00
|
|
|
{# code: language=ansible-jinja #}
|
2023-12-23 16:41:57 +00:00
|
|
|
# THIS FILE IS MANAGED BY ANSIBLE
|
|
|
|
|
|
|
|
|
|
# Common
|
|
|
|
|
listen_addresses = '*'
|
|
|
|
|
max_connections = 100
|
|
|
|
|
shared_buffers = 128MB
|
|
|
|
|
dynamic_shared_memory_type = posix
|
|
|
|
|
password_encryption = scram-sha-256
|
|
|
|
|
datestyle = 'iso, mdy'
|
|
|
|
|
timezone = '{{ timezone }}'
|
2023-12-27 23:00:12 +00:00
|
|
|
logging_collector = on
|
2023-12-23 16:41:57 +00:00
|
|
|
log_timezone = '{{ timezone }}'
|
|
|
|
|
lc_messages = 'en_US.utf8'
|
|
|
|
|
lc_monetary = 'en_US.utf8'
|
|
|
|
|
lc_numeric = 'en_US.utf8'
|
|
|
|
|
lc_time = 'en_US.utf8'
|
|
|
|
|
|
|
|
|
|
# WAL settings
|
|
|
|
|
wal_level = replica
|
|
|
|
|
max_wal_size = 2GB
|
|
|
|
|
min_wal_size = 80MB
|
|
|
|
|
|
|
|
|
|
# Archiving
|
2023-12-27 23:01:59 +00:00
|
|
|
archive_mode = off
|
2023-12-23 16:41:57 +00:00
|
|
|
archive_command = 'test ! -f {{ postgresql_wal_archive }}/%f && cp %p {{ postgresql_wal_archive }}/%f'
|
