| From: | loganathan P <plogandba(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Cc: | loganathan P <plogandba(at)gmail(dot)com> |
| Subject: | PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup |
| Date: | 2026-03-03 14:21:31 |
| Message-ID: | CAFX4Q9LhPByLecCuHu7gkmmNnDeKwG2CmG01y5ChOwtLrPdE=g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2026-03-03 14:48:01 | Re: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup |
| Previous Message | Laurenz Albe | 2026-03-03 12:30:17 | Re: Timezone handling with timestamp without time zone columns |