美文网首页
postgresql.conf配置

postgresql.conf配置

作者: 古飞_数据 | 来源:发表于2023-09-10 10:52 被阅读0次
[postgres@localhost pgdata]$ grep ^[a-Z] $PGDATA/postgresql.conf
listen_addresses = '*'          # what IP address(es) to listen on;
max_connections = 10000                   # (change requires restart)
shared_buffers = 128MB                  # min 128kB
dynamic_shared_memory_type = posix      # the default is the first option
max_wal_size = 1GB
min_wal_size = 80MB

log_destination = 'stderr'            # Valid values are combinations of 
logging_collector = on                # Enable capturing of stderr and csvlog
log_directory = 'log'                 # directory where log files are written
log_filename = 'postgresgl-%a.log'    # log file name pattern, 
log_rotation_age = 1d                 # Automatic rotation of logfiles will   
log_rotation_size = 0                 # Automatic rotation of logfiles wi11
log_truncate_on_rotation = on         # If on, an existing log file with the
log_line_prefix = '%m [%p] '          # special values:
log_timezone = 'Asia/Shanghai'
archive_mode = on               # enables archiving; off, on, or always
archive_command = 'test ! -f /pgccc/archive/%f && cp %p /pgccc/archive/%f'              # command to use to archive a logfile segment

datestyle = 'iso, mdy'
timezone = 'PRC'
lc_messages = 'en_US.UTF8'                      # locale for system error message
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_text_search_config = 'pg_catalog.english'

相关文章

网友评论

      本文标题:postgresql.conf配置

      本文链接:https://www.haomeiwen.com/subject/gbrsvdtx.html