Log retention query
Paul Brindusa <paulbrindusa88@gmail.com>
From: Paul Brindusa <paulbrindusa88@gmail.com>
To: pgsql-general <pgsql-general@postgresql.org>
Date: 2025-01-28T09:57:26Z
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@gmail.com