Обсуждение: Log file retention
Hi,How to keep log files only for 7 days
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
On Tue, Mar 19, 2024 at 4:04 AM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
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.
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 retentionOn Tue, Mar 19, 2024 at 4:04 AM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
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.
Thanks...I got the same info from postgrespro after searching this for long time..Can we also set for one month the same way?Thanks.On Tue, 19 Mar 2024, 13:50 Gabriel Guillem Barceló Soteras, <gbarcelo@parlamentib.es> wrote: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 retentionOn Tue, Mar 19, 2024 at 4:04 AM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
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.
Sent: Tuesday, March 19, 2024 2:11:28 PM
To: Gabriel Guillem Barceló Soteras <gbarcelo@parlamentib.es>
Cc: Ron Johnson <ronljohnsonjr@gmail.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Log file retention
Thanks...I got the same info from postgrespro after searching this for long time..Can we also set for one month the same way?Thanks.On Tue, 19 Mar 2024, 13:50 Gabriel Guillem Barceló Soteras, <gbarcelo@parlamentib.es> wrote: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 retentionOn Tue, Mar 19, 2024 at 4:04 AM Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
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.