O'Reilly logo
  • Mark Lehmann thinks this is interesting:

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:


Cover of PostgreSQL 9 Administration Cookbook - Second Edition


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.