![](https://seccdn.libravatar.org/avatar/e6d0c9f42625f8f9f45b6bd11ffbb77b.jpg?s=120&d=mm&r=g)
Hi Am Montag, 17. Mai 2021, 09:29:03 CEST schrieb Silvio Moioli:
On 14/05/2021 18.56, Thomas Weis wrote:
Yes, I expected that the smba tool would only archive a certain time frame. According to the documentation: "The smdba tool also manages your archives, keeping only the most recent backup, and the current archive of logs." Have I misinterpreted that and do I delete the superfluous archives manually or by script or does the smdba tool not do what it should do here?
My understanding is that `smdba backup-hot --enable=on` should run pg_archivecleanup under the hood, and the latter is supposed to clean up any stale WAL files, so that your backup only contains data in order to restore the database as of the time when it is running.
If that is not the case, it could be due to a bug.
Please check the database logs in /var/lib/pgsql/data/log/ . Sometimes it happens that the copy of the wal files to the backup dir failed. In this case it will try to copy again and again until the real problem is solved. In such a case the old wal files in the backup are not cleaned up. Typical solution: solve the problem and with the next backup things start to work again. -- Regards Michael Calmer -------------------------------------------------------------------------- Michael Calmer SUSE Software Solutions Germany GmbH, Maxfeldstr. 5, D-90409 Nuernberg T: +49 (0) 911 74053 0 F: +49 (0) 911 74053575 - e-mail: Michael.Calmer@suse.com -------------------------------------------------------------------------- SUSE Software Solutions Germany GmbH, GF: Felix Imendörffer (HRB 36809, AG Nürnberg)