Chapter 12. Providing High Availability
You can create backups of the data in local storages using BiHA and pg_probackup. In NFS and S3 storages, use BiHA and pg_probackup for the Postgres Pro AXE DBMS data and backup tools of the storage provider for the data.
The implementation of high availability depends on the required data restore time (refer to the table below).
Data Restore Time | Implementation |
|---|---|
Days | Full backups of the data |
Hours, minutes | Incremental backups of the data |
Seconds | Full backups of the data on standby servers or a fail-safe NFS/S3 storage |
Note
Most data processing scenarios do not have strict requirements on the restore time as compared to OLTP data processing scenarios and real-time analytics.