Re: Log retention query - Mailing list pgsql-general

On Tue, Jan 28, 2025 at 5:57 PM 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 appreciate this community and everything that
youdo 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@gmail.com
>


--
Regards
Junwang Zhao