From: Tom Lane <tgl@sss.pgh.pa.us>
To: Guillaume Lelarge <guillaume@lelarge.info>
cc: Nikhil Ingale <niks.bgm@gmail.com>, pgsql-admin@lists.postgresql.org
Subject: Re: Deleting the pg logs older than 30 days or certain time
In-reply-to: 
 <CAECtzeVJ4DLZ=+pdGC4eqCktzycshRFzN2Zynm4nh45oC7cdHQ@mail.gmail.com>
References: 
 <CALXkTpyeFNKOzWo3GSj=pAD4FitVnOcbk9s8dn_Zv_Dyu2KU3A@mail.gmail.com>
 <CAECtzeVJ4DLZ=+pdGC4eqCktzycshRFzN2Zynm4nh45oC7cdHQ@mail.gmail.com>
Comments: In-reply-to Guillaume Lelarge <guillaume@lelarge.info>
	message dated "Thu, 29 Jun 2023 09:46:54 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <1424080.1688037721.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Thu, 29 Jun 2023 07:22:01 -0400
Message-ID: <1424081.1688037721@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1424081.1688037721%40sss.pgh.pa.us>
Precedence: bulk

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