Re: Log retention query

On Tue, Jan 28, 2025 at 5:57 PM Paul Brindusa <paulbrindusa88(at)gmail(dot)com> wrote:
>
> 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?

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(at)gmail(dot)com
>

--
Regards
Junwang Zhao