2022-08-08 02:52:45 -04:00
|
|
|
port = 5432
|
|
|
|
|
listen_addresses='*'
|
2022-11-21 22:17:58 -05:00
|
|
|
unix_socket_directories='/tmp,{$APP_PATH}'
|
2022-08-08 02:52:45 -04:00
|
|
|
|
2022-08-08 11:07:22 -04:00
|
|
|
max_connections=200
|
2022-08-08 02:52:45 -04:00
|
|
|
max_wal_size = 1GB
|
|
|
|
|
min_wal_size = 80MB
|
2022-08-08 14:51:20 -04:00
|
|
|
shared_buffers = 128MB
|
|
|
|
|
work_mem = 4MB
|
|
|
|
|
effective_cache_size = 4GB
|
|
|
|
|
temp_buffers = 8MB
|
|
|
|
|
max_prepared_transactions = 0
|
|
|
|
|
max_stack_depth = 2MB
|
|
|
|
|
bgwriter_lru_maxpages = 100
|
|
|
|
|
max_worker_processes = 8
|
|
|
|
|
dynamic_shared_memory_type = posix
|
|
|
|
|
|
2022-08-08 02:52:45 -04:00
|
|
|
|
|
|
|
|
log_timezone = 'Asia/Shanghai'
|
|
|
|
|
datestyle = 'iso, ymd'
|
|
|
|
|
timezone = 'Asia/Shanghai'
|
|
|
|
|
default_text_search_config = 'pg_catalog.simple'
|
2022-08-08 13:48:09 -04:00
|
|
|
|
|
|
|
|
|
2022-08-10 04:14:39 -04:00
|
|
|
# 主配置
|
|
|
|
|
#archive_mode = on
|
|
|
|
|
#archive_command = 'test ! -f {$APP_PATH}/archivelog/%f && cp %p {$APP_PATH}/archivelog/%f'
|
|
|
|
|
#wal_level = replica
|
|
|
|
|
#max_wal_senders = 10
|
|
|
|
|
#wal_sender_timeout = 60s
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
# 从配置
|
|
|
|
|
#hot_standby = on
|
2022-08-11 04:52:21 -04:00
|
|
|
#primary_conninfo = 'host=192.168.0.100 port=5432 user=replica password=123456'
|
2022-08-10 04:14:39 -04:00
|
|
|
#max_standby_streaming_delay = 30s
|
|
|
|
|
#wal_receiver_status_interval = 10s
|
|
|
|
|
#hot_standby_feedback = on
|
2022-08-11 04:52:21 -04:00
|
|
|
#recovery_target_timeline= 'latest'
|
2022-08-10 04:14:39 -04:00
|
|
|
|
|
|
|
|
|
2022-08-08 13:48:09 -04:00
|
|
|
logging_collector = on
|
|
|
|
|
log_destination = 'stderr'
|
|
|
|
|
log_directory = '{$APP_PATH}/logs'
|
|
|
|
|
log_filename = 'postgresql-%Y-%m-%d.log'
|
|
|
|
|
log_statement = all
|
2022-08-09 23:22:01 -04:00
|
|
|
log_rotation_age = 7d
|
|
|
|
|
log_rotation_size = 100MB
|
2022-08-08 13:48:09 -04:00
|
|
|
log_min_duration_statement = 5000
|
