MIME-Version: 1.0
From: Paul Brindusa <paulbrindusa88@gmail.com>
Date: Tue, 28 Jan 2025 09:57:26 +0000
Message-ID: <CAFeSbqjnRXNZ72NdD+G6ScKKBTQXAxpMk=XyH1sPGs+L2atF_A@mail.gmail.com>
Subject: Log retention query
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000ec9b5062cc13993"
Archived-At: <https://www.postgresql.org/message-id/CAFeSbqjnRXNZ72NdD%2BG6ScKKBTQXAxpMk%3DXyH1sPGs%2BL2atF_A%40mail.gmail.com>
Precedence: bulk

--0000000000000ec9b5062cc13993
Content-Type: text/plain; charset="UTF-8"

Good morning everyone,

Before I get on with today's problem, I would like to say how much I
appreciate this community and everything that you do for end users.

In today's problem I would like to understand if the following lines in our
config handle the log rotation for our clusters?

        log_checkpoints: on
        logging_collector: on
        log_truncate_on_rotation: on
        log_rotation_age: 1d
        log_rotation_size: 1GB
        log_error_verbosity: verbose

I have been deleting the logs manually for the last month, since I am
confused how the log collector rotates them.

Am looking to delete logs older than 180 days. What are we doing wrong in
the config?

-- 
Kind Regards,
Paul Brindusa
paulbrindusa88@gmail.com

--0000000000000ec9b5062cc13993
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Good morning everyone,</div><div><br></div><div>Befor=
e I get on with today&#39;s problem, I would like to say how much I appreci=
ate this community and everything that you do for end users.</div><div><br>=
</div><div>In today&#39;s problem I would like to understand if the followi=
ng lines in our config handle the log rotation for our clusters?</div><div>=
<br></div><div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 log_checkpoints: on<br>=C2=A0 =
=C2=A0 =C2=A0 =C2=A0 logging_collector: on<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 l=
og_truncate_on_rotation: on<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 log_rotation_age=
: 1d<br>=C2=A0 =C2=A0 =C2=A0 =C2=A0 log_rotation_size: 1GB</div><div>=C2=A0=
 =C2=A0 =C2=A0 =C2=A0 log_error_verbosity: verbose</div><div><br></div><div=
>I have been deleting the logs manually for the last month, since I am conf=
used how the log collector rotates them.=C2=A0</div><div><br></div><div>Am =
looking to delete logs older than 180 days. What are we doing=C2=A0wrong in=
 the config?</div><div><br></div><span class=3D"gmail_signature_prefix">-- =
</span><br><div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gma=
il_signature"><div dir=3D"ltr"><div>Kind Regards,</div><div>Paul Brindusa</=
div><div><a href=3D"mailto:paulbrindusa88@gmail.com" target=3D"_blank">paul=
brindusa88@gmail.com</a></div><div><br></div></div></div></div>

--0000000000000ec9b5062cc13993--