25 lines
586 B
Plaintext
25 lines
586 B
Plaintext
data_directory = '/data/homer/postgresql'
|
|
listen_addresses = '127.0.0.1'
|
|
port = 5432
|
|
password_encryption = 'scram-sha-256'
|
|
timezone = 'UTC'
|
|
log_timezone = 'UTC'
|
|
|
|
max_connections = 100
|
|
shared_buffers = '512MB'
|
|
effective_cache_size = '2GB'
|
|
maintenance_work_mem = '128MB'
|
|
work_mem = '8MB'
|
|
min_wal_size = '256MB'
|
|
max_wal_size = '2GB'
|
|
checkpoint_completion_target = 0.9
|
|
random_page_cost = 1.1
|
|
|
|
logging_collector = on
|
|
log_directory = '/var/log/postgresql'
|
|
log_filename = 'postgresql-homer-%Y-%m-%d.log'
|
|
log_rotation_age = '1d'
|
|
log_truncate_on_rotation = on
|
|
log_min_duration_statement = 1000
|
|
|