This repository has been archived by the owner on Jun 15, 2020. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 2
/
pg.conf
52 lines (35 loc) · 1.47 KB
/
pg.conf
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
listen_addresses = '*'
# comma-separated list of addresses;
# defaults to 'localhost'; use '*' for all
#port = 5432 # (change requires restart)
max_connections = 100 # (change requires restart)
# - Security and Authentication -
authentication_timeout = 10s # 1s-600s
ssl = on
#ssl_ciphers = 'HIGH:MEDIUM:+3DES:!aNULL' # allowed SSL ciphers
#ssl_prefer_server_ciphers = on # (change requires restart)
#ssl_ecdh_curve = 'prime256v1' # (change requires restart)
#ssl_cert_file = '/etc/ega/pg.cert'
#ssl_key_file = '/etc/ega/pg.key'
#ssl_ca_file = '/etc/ega/CA.cert'
#ssl_crl_file = '' # (change requires restart)
password_encryption = scram-sha-256
#row_security = on
# - Memory -
shared_buffers = 128MB # min 128kB
dynamic_shared_memory_type = posix # the default is the first option
# - Logs -
log_timezone = 'UTC'
#------------------------------------------------------------------------------
# CLIENT CONNECTION DEFAULTS
#------------------------------------------------------------------------------
# - Locale and Formatting -
datestyle = 'iso, mdy'
timezone = 'UTC'
# These settings are initialized by initdb, but they can be changed.
lc_messages = 'en_US.utf8' # locale for system error message strings
lc_monetary = 'en_US.utf8' # locale for monetary formatting
lc_numeric = 'en_US.utf8' # locale for number formatting
lc_time = 'en_US.utf8' # locale for time formatting
# default configuration for text search
default_text_search_config = 'pg_catalog.english'