PostgreSQL 12 High Availability Cookbook - Third Edition

Managing WAL files with WAL-E

With WAL-E installed, we can now use it to transmit transaction WAL files to and from our cloud service of choice. Remember, by keeping WAL files in a remote location, they're isolated from natural disasters, data center outages, being overwritten, and any number of unplanned events. Consider cloud storage as a form of long-term archival of our transaction logs.

Why is this important? Remember our mantra: outages are unavoidable. We can take multiple steps to avoid them, but sometimes the situation is beyond human intervention. Sometimes, we simply need to rebuild. Offsite backup of WAL files means we can apply PITR to a recent backup and reach the last known stable state of our data. Since WAL-E integrates directly ...