<< Click to Display Table of Contents >> Exemplo de postgresql.conf |
![]() ![]() ![]() |
Este exemplo é baseado em um servidor com 1Gb de memória:
listen_addresses = '*'
port = 5432
max_connections = 50
shared_buffers = 32768
work_mem = 4MB
maintenance_work_mem = 16MB
max_fsm_pages = 153600
fsync = on
archive_mode = on
archive_command = 'cp -i %p /market/backups/wal/%f </dev/null'
log_destination = 'stderr'
logging_collector = on
log_directory = 'pg_log'
log_filename = 'postgresql-%a.log'
log_truncate_on_rotation = on
log_rotation_age = 1d
log_rotation_size = 0
silent_mode = on
log_line_prefix = '%d %h %t'
log_statement = 'all'
autovacuum = off
lc_messages = 'pt_BR.UTF-8'
lc_monetary = 'pt_BR.UTF-8'
lc_numeric = 'pt_BR.UTF-8'
lc_time = 'pt_BR.UTF-8'
default_text_search_config = 'pg_catalog.portuguese'