Andrey Borodin - Hidden gems of WAL-G backup tool (PGConf.EU 2024)
The typical workflow of any backup solution is relatively straightforward: set up a point-in-time recovery archive, create a backup rotation schedule, and verify the restoration process from time to time. However, WAL-G provides some useful features that can be useful for database administrators in a stormy situation: 1. Performance adjustments to modify the usual "cheap backups - fast restores" mode. 2. Advanced consistency monitoring capabilities to ensure that backups are accurate. 3. Quick standby catch-up and other high availability cluster features. 4. Various methods to extract a changeset for incremental backups. Additionally, I will discuss the future roadmap, including consistent backups for sharded clusters and the use of advanced S3 capabilities.
Discussion (0)
Join the discussion!
Subscribe to post comments and join our community of developers.