Recovery planning

Planning plays an important role in a disaster recovery solution for any IT subsystem, database included.

The role of planning

Planning plays an important role in a disaster recovery solution for any IT subsystem, database included.

It involves defining objectives and processes, training human resources, setting up proper IT infrastuctures (network, hardware and software) and finally estimating costs.

Recovery Point Objective (RPO)

PostgreSQL can achieve important results in terms of recovery point objective (RPO), from very small windows of data loss to even Zero data loss. Barman is a software for disaster recovery that simplifies both backup and recovery processes, reducing the overhead and therefore the cost of maintenance of a PostgreSQL disaster recovery solution.