blob: fe7858e893f96e90c7a763e80fd5c7556d68ec5d (
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
35
36
37
38
39
40
41
|
listen_addresses = 'localhost, @vpn_ipv4@'
port = 5432
max_connections = 128
superuser_reserved_connections = 16
password_encryption = scram-sha-256
db_user_namespace = off
row_security = on
shared_buffers = 256MB
huge_pages = on
temp_buffers = 8MB
max_prepared_transactions = 0
work_mem = 16MB
maintenance_work_mem = 512MB
autovacuum_work_mem = -1
max_stack_depth = 4MB
dynamic_shared_memory_type = posix
log_destination = 'stderr'
logging_collector = on
log_directory = 'log'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_file_mode = 0600
log_truncate_on_rotation = off
log_rotation_age = 1d
log_rotation_size = 10MB
log_line_prefix = '%m %d %u [%p]'
datestyle = 'iso, mdy'
intervalstyle = 'postgres'
timezone_abbreviations = 'Default'
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'
|