/
postgresql.conf.template
109 lines (81 loc) · 3.91 KB
/
postgresql.conf.template
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
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
#------------------------------------------------------------------------------
# FILE LOCATIONS
#------------------------------------------------------------------------------
data_directory = '__DATA_DIRECTORY__'
hba_file = '__CONF_DIRECTORY__/main/pg_hba.conf'
ident_file = '__CONF_DIRECTORY__/main/pg_ident.conf'
external_pid_file = '__RUN_DIRECTORY__/__PG_VERSION__-main.pid'
#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------
listen_addresses = '*'
port = __PORT__
max_connections = 250
unix_socket_directories = '__RUN_DIRECTORY__'
ssl = on
ssl_ciphers = 'DEFAULT:!LOW:!EXP:!MD5:@STRENGTH'
ssl_cert_file = '__CONF_DIRECTORY__/ssl/server.crt'
ssl_key_file = '__CONF_DIRECTORY__/ssl/server.key'
#------------------------------------------------------------------------------
# RESOURCE USAGE (except WAL)
#------------------------------------------------------------------------------
shared_buffers = 128MB
#------------------------------------------------------------------------------
# WRITE AHEAD LOG
#------------------------------------------------------------------------------
#------------------------------------------------------------------------------
# REPLICATION
#------------------------------------------------------------------------------
wal_level = __WAL_LEVEL__
max_wal_senders = 10
wal_keep_segments = 8 # __NOT_IF_PG_13__ __NOT_IF_PG_14__ __NOT_IF_PG_15__ __NOT_IF_PG_16__
wal_keep_size = 128 # __NOT_IF_PG_9.5__ __NOT_IF_PG_9.6__ __NOT_IF_PG_10__ __NOT_IF_PG_11__ __NOT_IF_PG_12__
hot_standby = on
max_replication_slots = 10
#------------------------------------------------------------------------------
# QUERY TUNING
#------------------------------------------------------------------------------
#------------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#------------------------------------------------------------------------------
log_line_prefix = '%t '
log_timezone = 'UTC'
client_min_messages = ERROR
log_min_messages = INFO
log_min_error_statement = FATAL
log_destination = 'stderr'
#------------------------------------------------------------------------------
# RUNTIME STATISTICS
#------------------------------------------------------------------------------
shared_preload_libraries = '__PRELOAD_LIB__'
#------------------------------------------------------------------------------
# AUTOVACUUM PARAMETERS
#------------------------------------------------------------------------------
#------------------------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
#------------------------------------------------------------------------------
datestyle = 'iso, mdy'
timezone = 'UTC'
lc_messages = 'C'
lc_monetary = 'C'
lc_numeric = 'C'
lc_time = 'C'
default_text_search_config = 'pg_catalog.english'
tcp_keepalives_idle = 30
tcp_keepalives_interval = 30
#------------------------------------------------------------------------------
# LOCK MANAGEMENT
#------------------------------------------------------------------------------
#------------------------------------------------------------------------------
# VERSION/PLATFORM COMPATIBILITY
#------------------------------------------------------------------------------
#------------------------------------------------------------------------------
# ERROR HANDLING
#------------------------------------------------------------------------------
#------------------------------------------------------------------------------
# CONFIG FILE INCLUDES
#------------------------------------------------------------------------------
include '__PG_AUTOTUNE_CONF__'
#------------------------------------------------------------------------------
# CUSTOMIZED OPTIONS
#------------------------------------------------------------------------------