From: | vignesh kumar <vigneshkumar(dot)venugopal(at)outlook(dot)com> |
---|---|
To: | Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>, Gabriel Guillem Barceló Soteras <gbarcelo(at)parlamentib(dot)es> |
Cc: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Log file retention |
Date: | 2024-03-20 06:57:05 |
Message-ID: | MN0PR20MB491205677A2A9585A6BE9DF287332@MN0PR20MB4912.namprd20.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Use log rotate functionality instead on Linux. You can specify the size , date and retention period and file extn suffix as well.. hope this helps
Get Outlook for Android<https://aka.ms/AAb9ysg>
________________________________
From: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
Sent: Tuesday, March 19, 2024 2:11:28 PM
To: Gabriel Guillem Barceló Soteras <gbarcelo(at)parlamentib(dot)es>
Cc: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>; Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: 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<mailto: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<mailto:gbarcelo(at)parlamentib(dot)es>> wrote:
From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com<mailto:ronljohnsonjr(at)gmail(dot)com>>
Date: Tuesday, 19 March 2024 at 09:16
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org<mailto: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<mailto: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:
* 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.
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar | 2024-03-20 07:08:53 | Re: Validation of db post minor upgradation |
Previous Message | vignesh kumar | 2024-03-20 06:49:47 | Re: Validation of db post minor upgradation |