Log retention query

From: Paul Brindusa <paulbrindusa88(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Log retention query
Date: 2025-01-28 09:57:26
Message-ID: CAFeSbqjnRXNZ72NdD+G6ScKKBTQXAxpMk=XyH1sPGs+L2atF_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Vanns 2025-01-28 12:13:53 Re: Parallel workers via functions?
Previous Message Laurenz Albe 2025-01-28 04:47:11 Re: Parallel workers via functions?