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(at)parlamentib(dot)es> wrote:

> *From: *Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
> *Date: *Tuesday, 19 March 2024 at 09:16
> *To: *Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
> *Subject: *Re: Log file retention
>
> On Tue, Mar 19, 2024 at 4:04 AM Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)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:
>
>
>
> 1. Edit the postgresql.conf File:
> 2. Locate the postgresql.conf file for your PostgreSQL installation.
> 3. Configure the Following Parameters:
> 1. Set log_filename to server_log.%a. This will create one log file
> per day named server_log.Mon, server_log.Tue, etc.
> 2. Enable log_truncate_on_rotation to automatically overwrite last
> week’s log with this week’s log.
> 3. Set log_rotation_age to 1440 (minutes), which corresponds to 24
> hours. This ensures that logs are rotated daily.
> 4. 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.
>
>
>