2024-11-10 21:17:33 +00:00
|
|
|
postgres_listen_addresses: '*'
|
|
|
|
|
postgres_port: 5432
|
|
|
|
|
|
|
|
|
|
postgres_hba_entries:
|
|
|
|
|
- { type: 'host', database: 'all', user: 'all', address: '0.0.0.0/0', method: 'md5' }
|
|
|
|
|
- { type: 'local', database: 'all', user: 'all', address: '', method: 'trust' }
|
|
|
|
|
|
2024-12-08 19:11:48 +00:00
|
|
|
backup_dir: "/var/backups/postgresql"
|
2024-11-10 21:17:33 +00:00
|
|
|
postgres_user: "postgres"
|
2024-12-08 19:11:48 +00:00
|
|
|
postgres_db: "mydb"
|
|
|
|
|
|
|
|
|
|
postgres_max_connections: 100
|
|
|
|
|
postgres_shared_buffers: '128MB'
|
|
|
|
|
postgres_effective_cache_size: '4GB'
|
|
|
|
|
postgres_maintenance_work_mem: '64MB'
|
|
|
|
|
postgres_checkpoint_completion_target: 0.7
|
|
|
|
|
postgres_wal_buffers: '16MB'
|
|
|
|
|
postgres_default_statistics_target: 100
|
