Re:Wal-E: Continuous Archiving for Postgres
by 1zq on Monday February 06, 2017 @12:16AM
(#13576692)
We've been using WAL-E for about 4 years and it has worked well for us.
One way to continuously test that your files are being pushed up correctly is to have a hot standby pulling WAL files from S3 and check periodically that the data in the standby looks sane.
Although not a replacement for full "restore from backups" tests (because that process involves a base backup too), it's a good way to quickly notice issues preventing WAL files from being stored on S3 or from being decrypted.
One way to continuously test that your files are being pushed up correctly is to have a hot standby pulling WAL files from S3 and check periodically that the data in the standby looks sane.
Although not a replacement for full "restore from backups" tests (because that process involves a base backup too), it's a good way to quickly notice issues preventing WAL files from being stored on S3 or from being decrypted.