Think Your Postgres Backups and Disaster Recovery Are Safe? Let's Talk. by Payal Singh

Presented at PGConfNYC 2015

Disaster recovery is perhaps the most ignored aspect of managing PostgreSQL in production systems, and its value is only realized in a moment of crisis. If not done right, absence of backup and recovery strategies can make one repent for days, if not months after. Even when catered to, majority of production systems only have at most one defined backup and recovery strategy, not realizing the benefits of using a hybrid solution or a combination of multiple types of backups and recovery approaches. Contrary to common perception of treating disaster management as a one model fits all philosophy, emphasis should be given on how various types of backups have been optimized for specific kinds of disaster scenarios.