Blame public/fs/home/pgsql/data/postgresql.conf.in
|
root@culturestrings |
2caf08 |
listen_addresses = 'localhost, @vpn_ipv4@'
|
|
root@culturestrings |
dc05eb |
port = 5432
|
|
root@culturestrings |
dc05eb |
max_connections = 128
|
|
root@culturestrings |
dc05eb |
superuser_reserved_connections = 16
|
|
root@culturestrings |
dc05eb |
|
|
root@culturestrings |
dc05eb |
password_encryption = scram-sha-256
|
|
root@culturestrings |
dc05eb |
db_user_namespace = off
|
|
root@culturestrings |
dc05eb |
row_security = on
|
|
root@culturestrings |
dc05eb |
|
|
root@culturestrings |
dc05eb |
shared_buffers = 256MB
|
|
root@culturestrings |
dc05eb |
huge_pages = on
|
|
root@culturestrings |
dc05eb |
temp_buffers = 8MB
|
|
root@culturestrings |
dc05eb |
max_prepared_transactions = 0
|
|
root@culturestrings |
dc05eb |
|
|
root@culturestrings |
dc05eb |
work_mem = 16MB
|
|
root@culturestrings |
dc05eb |
maintenance_work_mem = 512MB
|
|
root@culturestrings |
dc05eb |
autovacuum_work_mem = -1
|
|
root@culturestrings |
dc05eb |
max_stack_depth = 4MB
|
|
root@culturestrings |
dc05eb |
dynamic_shared_memory_type = posix
|
|
root@culturestrings |
dc05eb |
|
|
root@culturestrings |
dc05eb |
log_destination = 'stderr'
|
|
root@culturestrings |
dc05eb |
logging_collector = on
|
|
root@culturestrings |
dc05eb |
|
|
root@culturestrings |
dc05eb |
log_directory = 'log'
|
|
root@culturestrings |
dc05eb |
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
|
|
root@culturestrings |
dc05eb |
log_file_mode = 0600
|
|
root@culturestrings |
dc05eb |
log_truncate_on_rotation = off
|
|
root@culturestrings |
dc05eb |
log_rotation_age = 1d
|
|
root@culturestrings |
dc05eb |
log_rotation_size = 10MB
|
|
root@culturestrings |
dc05eb |
log_line_prefix = '%m %d %u [%p]'
|
|
root@culturestrings |
dc05eb |
|
|
root@culturestrings |
dc05eb |
datestyle = 'iso, mdy'
|
|
root@culturestrings |
dc05eb |
intervalstyle = 'postgres'
|
|
root@culturestrings |
dc05eb |
timezone_abbreviations = 'Default'
|
|
root@culturestrings |
dc05eb |
|
|
root@culturestrings |
dc05eb |
lc_messages = 'en_US.UTF-8'
|
|
root@culturestrings |
dc05eb |
lc_monetary = 'en_US.UTF-8'
|
|
root@culturestrings |
dc05eb |
lc_numeric = 'en_US.UTF-8'
|
|
root@culturestrings |
dc05eb |
lc_time = 'en_US.UTF-8'
|
|
root@culturestrings |
dc05eb |
|
|
root@culturestrings |
dc05eb |
default_text_search_config = 'pg_catalog.english'
|