MIME-Version: 1.0
References: <CAFeSbqjnRXNZ72NdD+G6ScKKBTQXAxpMk=XyH1sPGs+L2atF_A@mail.gmail.com>
In-Reply-To: <CAFeSbqjnRXNZ72NdD+G6ScKKBTQXAxpMk=XyH1sPGs+L2atF_A@mail.gmail.com>
From: Junwang Zhao <zhjwpku@gmail.com>
Date: Tue, 28 Jan 2025 20:19:28 +0800
Message-ID: <CAEG8a3+p5r3Mk4WPQKxTiExHNZXUfd3sTm1p9CpP9Fn3Jbf3JA@mail.gmail.com>
Subject: Re: Log retention query
To: Paul Brindusa <paulbrindusa88@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAEG8a3%2Bp5r3Mk4WPQKxTiExHNZXUfd3sTm1p9CpP9Fn3Jbf3JA%40mail.gmail.com>
Precedence: bulk

On Tue, Jan 28, 2025 at 5:57=E2=80=AFPM Paul Brindusa <paulbrindusa88@gmail=
.com> wrote:
>
> Good morning everyone,
>
> 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.
>
> In today's problem I would like to understand if the following lines in o=
ur 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 con=
fused how the log collector rotates them.
>
> Am looking to delete logs older than 180 days. What are we doing wrong in=
 the config?

I doubt Postgres can do this, but you can do this by adding a crontab
entry. e.g.

0 2 * * * find /path/to/logs -type f -mtime +180 -name "*.log" -exec rm {} =
\;

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


--=20
Regards
Junwang Zhao