summaryrefslogtreecommitdiff
path: root/public/fs/home/pgsql/data/postgresql.conf.in
blob: 42a1c26e655e73ef03a1d174c1cdff39050a0abf (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
42
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
replacement_sort_tuples         = 150000
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'