Re: Deleting the pg logs older than 30 days or certain time - Mailing list pgsql-admin

From MichaelDBA
Subject Re: Deleting the pg logs older than 30 days or certain time
Date
Msg-id 017a8f0f-2a35-297e-764e-5f77a1af4ff3@sqlexec.com
Whole thread Raw
In response to Re: Deleting the pg logs older than 30 days or certain time  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
example: log_filename = 'postgresql-%a.log'


Tom Lane wrote on 6/29/2023 7:22 AM:
Guillaume Lelarge <guillaume@lelarge.info> writes:
Le jeu. 29 juin 2023 à 09:13, Nikhil Ingale <niks.bgm@gmail.com> a écrit :
Can postgresql internal log rotation configuration mechanism delete the
log files older than a specific period of time?
No.
It will work if you choose a filename pattern such that old files are
overwritten on some cycle.  logrotate is a more flexible answer
of course.
			regards, tom lane




Regards,

Michael Vitale

Michaeldba@sqlexec.com

703-600-9343 


Attachment

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Deleting the pg logs older than 30 days or certain time
Next
From: "Wetmore, Matthew (CTR)"
Date:
Subject: Deleting the pg logs older than 30 days or certain time