If you wish to have multiple standby nodes, then a shared archive would be a single point of failure and should be avoided, so each standby should maintain its own archive. We must modify the
archive_command to be a script, rather than execute the command directly. This allows us to handle archiving to multiple destinations:
- Setting up file-based replication – deprecated
- from PostgreSQL 9 Administration Cookbook - Second Edition
- Publisher: Packt Publishing
- Released: April 2015
Using barman and replication needs the archives to be sent to multiple servers, so make a script that rsyncs the files to more than one server.
Share this highlighthttp://www.safaribooksonline.com/a/postgresql-9-administration/6724605/