Disaster recovery

Crunchy Bridge protects your database against failures and disasters. Disaster recovery is automatically enabled for all databases, so your database can be recovered if a failure or disaster occurs.

Disaster recovery is the process of archiving your data to an additional data store, typically cold storage. Cold storage offers 11 9s (99.999999999% durability), which provides strong protection against data loss.

Disaster recovery is accomplished by capturing physical backups from Postgres and archiving the write-ahead log (WAL). If a disaster occurs, we automatically restore from the most recent backup and replay the archived WAL.

Because disaster recovery is enabled on all databases, you don't need to take any additional steps.

Recovery time

Disaster recovery time isn't guaranteed. Restoring the base backup scales with how much data you have, and replaying WAL after that scales with how much you've written since the backup used for recovery.

As a rough guide, disaster recovery takes about 1 hour per 200 GB of data. It can take longer at times if you have a database with high transaction throughput.