PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup - Mailing list pgsql-general

From loganathan P
Subject PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup
Date
Msg-id CAFX4Q9LhPByLecCuHu7gkmmNnDeKwG2CmG01y5ChOwtLrPdE=g@mail.gmail.com
Whole thread
Responses Re: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup
Re: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup
List pgsql-general
Dear Team,

We have PostgreSQL 15 and PostgreSQL 17 databases running in separate environments on different servers. Each database is approximately 1.5 TB in size and highly active, generating around 500 GB of archive logs per day. We have VM SRM replication configured.

The archive log partition reaches 95–100% utilization before backups are taken. After the backups are completed, we must manually remove the archived log files to free up space.

Could you please advise whether PostgreSQL has any built-in parameters or mechanisms to automatically delete archived log files once they have been successfully backed up?



Thanks.

Regards,
Loganathan P

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Timezone handling with timestamp without time zone columns
Next
From: Laurenz Albe
Date:
Subject: Re: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup