From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tuesday, 19 March 2024 at 09:16
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Log file retention
Hi,
How to keep log files only for 7 days
logrotate? A bash script in a cron job?
I think it is the default behaviour on default install:
- Edit the postgresql.conf File:
- Locate the postgresql.conf file for your PostgreSQL installation.
- Configure the Following Parameters:
- Set log_filename to server_log.%a. This will create one log file per day named server_log.Mon, server_log.Tue, etc.
- Enable log_truncate_on_rotation to automatically overwrite last week’s log with this week’s log.
- Set log_rotation_age to 1440 (minutes), which corresponds to 24 hours. This ensures that logs are rotated daily.
- Example Configuration:
log_filename = 'server_log.%a'
log_truncate_on_rotation = on
log_rotation_age = 1440
Still keep an eye on log_rotation_size
After making these changes, restart your PostgreSQL server for the new settings to take effect.