Re: Log file retention

Instead of %a should we use postgresql-%d.log ?

On Tue, 19 Mar 2024, 13:57 Rajesh Kumar, <rajeshkumar(dot)dba09(at)gmail(dot)com>
wrote:

> 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.
>>
>>
>>
>