PostgreSQL 12 High Availability Cookbook - Third Edition

Streaming replicas

Barman does not have a mode to initialize the newly restored server as a streaming replica of the original. This would require setting primary_conninfo in either recovery.conf or postgresql.conf of the newly restored system. However, Barman only knows how to connect to the backup source as the user we've configured for backup purposes.

Since this could be considered a security exploit, it's up to us to specify the correct DSN necessary to transform the new server to a streaming replica. Barman does, however, provide a parameter named --standby-mode, which will set create a standby.signal file in Postgres 12 and above, or add the equivalent standby_mode setting to recovery.conf for older installations.

Still, we need to ...