PostgreSQL 12 High Availability Cookbook - Third Edition

RPO zero

RPO zero is an industry term that stands for Recovery Point Objective of zero. In the context of a backup, it means we've lost zero committed transactions and can recover to full operating capacity as if nothing had happened.

Unlike most other backup management suites, Barman provides the capability of obtaining transaction data directly from the PostgreSQL replication stream as we demonstrated in this recipe. It's also important to understand that Barman supports synchronous replication as well.

To begin, we check the pg-primary server to find the name Barman assigns:

barman show-server pg-primary | grep archiver_name 

The result of this command will be the value we use for synchronous_standby_names in postgresql.conf. It would ...