On Mon, Jul 16, 2018 at 8:35 PM, Ravi Krishna <sravikrish...@gmail.com> wrote:
> Not sure I am following this. Did Google release this because PG backups > are not 100% reliable or the data corruption can occur due to hardware > failure. > > http://www.eweek.com/cloud/google-releases-open-source- > tool-that-checks-postgres-backup-integrity?utm_medium= > email&utm_campaign=EWK_NL_EP_20180713_STR5L2&dni=450493554&rni=24844166 > The rule of thumb is you should verify that your backups can be restored before you consider them reliable. You don't want to end up in a disaster recovery situation and find that your backups have been corrupted in any way shape or form. Many things can break your backups, especially if they are automated and have many steps involved. One way to do this is to actually restore the data on a different system and compare. This tool appears to do the comparison for you directly to the dump, increasing confidence that it is reliable.
