Sample Header Ad - 728x90

Delete WAL archive files

1 vote
1 answer
3150 views
I have around 200Gb of **WAL archives**. Can I just delete them all without considering any database restoration? I am just asking whether it is safe to delete them all or at least 50% of them. I read a book that one must issue pg_basebackup and then delete WAL archives that are older than the "**.backup**" file. But, the postgres manual says that pg_basebackup is for cluster backup. My database is not running on cluster mode. So, is pg_basebackup still relevant for me ? If not, how do I do backup ? I want to implement PITR and may be need something like base backup. I am using Postgres 12. Thanks
Asked by padjee (337 rep)
Sep 6, 2022, 04:36 PM
Last activity: Jul 22, 2024, 08:04 AM