Ajay Dwivedi switches out log files:
In my organisation, we have started building PostgreSQL Clusters with Patroni + Consul. In PostgreSQL we enable a few extensions like pg_stat_statements to ensure we don’t miss any performance impacting query.
But this generates too much log in active servers, leading to PostgreSQL log bloating. Thus, it becomes important to ensure log files do not consume beyond an agreed amount of disk space. For this reason, I implemented the following log rotation steps for Postgresql –
- Ensure to set proper log file name for PostgresSQL logging_collector.
- Add a logrotate policy on linux system for postgres logs directory.
- Add a cron job for running logrotate policy more frequently.
Click through to see how.