PostgreSQL 12 High Availability Cookbook - Third Edition

Cloning from Barman

Since repmgr and Barman are both developed by 2ndQuadrant, they have been designed to be integrated if this is what is wanted. One reason that we might decide to do this is to reduce I/O strain on the primary node when creating a new clone. It's also very easy to configure.

Assuming that we've already explored the recipes in the chapter on backup management, we could add these two settings to repmgr.conf and clones would be constructed from a backup rather than the primary node:

barman_host='barman@pg-backup' 
    barman_server='pg-primary' 

Since repmgr knows the parameters that Barman expects, it can invoke all the commands necessary to recover the latest backup on the local node. Of course, this assumes that we have already ...