pgBackRest is a well-known powerful backup and
restore tool. It offers a lot of possibilities.
While pg_basebackup is commonly used to setup the initial database copy for
the Streaming Replication, it could be interesting to reuse a previous
database backup (eg. taken with pgBackRest) to perform this initial copy.
--delta option provided by pgBackRest can help us to
re-synchronize an old secondary server without having to rebuild it from
To reduce the load on the primary server during a backup, pgBackRest even
allows to take backups from a standby server.
We’ll see in this blog post how to do that.