Message-ID: <f6fb8364619a84f9b535edaaceb568dc2377da0d.camel@cybertec.at>
Subject: Re: Log retention query
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Paul Brindusa <paulbrindusa88@gmail.com>, pgsql-general
	 <pgsql-general@postgresql.org>
Date: Tue, 28 Jan 2025 14:28:36 +0100
In-Reply-To: <CAFeSbqjnRXNZ72NdD+G6ScKKBTQXAxpMk=XyH1sPGs+L2atF_A@mail.gmail.com>
References: 
	<CAFeSbqjnRXNZ72NdD+G6ScKKBTQXAxpMk=XyH1sPGs+L2atF_A@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/f6fb8364619a84f9b535edaaceb568dc2377da0d.camel%40cybertec.at>
Precedence: bulk

On Tue, 2025-01-28 at 09:57 +0000, Paul Brindusa wrote:
> Good morning everyone,
>=20
> Before I get on with today's problem, I would like to say how much I appr=
eciate this community and everything that you do for end users.
>=20
> In today's problem I would like to understand if the following lines in o=
ur config handle the log rotation for our clusters?
>=20
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 log_checkpoints: on
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 logging_collector: on
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 log_truncate_on_rotation: on
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 log_rotation_age: 1d
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 log_rotation_size: 1GB
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 log_error_verbosity: verbose
>=20
> I have been deleting the logs manually for the last month, since I am con=
fused how the log collector rotates them.=C2=A0
>=20
> Am looking to delete logs older than 180 days. What are we doing=C2=A0wro=
ng in the config?

It all depends on how you configured "log_filename".

If the setting is "postgresql-%a.log" or "postgresql-%d.log", PostgreSQL
will recycle the old log files once a week or once a month.

If the setting is the default "postgresql-%Y-%m-%d_%H%M%S.log", the same
log file name will never be reused, and there will be no log rotation.

PostgreSQL doesn't actively delete old log files.

Yours,
Laurenz Albe