On Sep 15, 2014, at 2:06 PM, Magnus Persson <magnus.e.persson@gmail.com> wrote:
> If we consider that I for some reason or the other can't use pg_dumpall against the production clusters, what are my
options?One idea is that of using asynchronous replication and pull the dumps off of them. Are there any pitfalls
relatedto the replication? During normal operations, will postgres ensure that the state on the slaves always reflect
thestate of the masters? In effect it would work similar to if I did the dump on the production servers? I recall
readingsomething about asynchronous replication, but I'm unsure of what it was exactly or if it affects backups.
Yes, this approach works, but it is not without possible problems. You may have to repeat a failed backup because of
queryconflicts. See
http://www.postgresql.org/docs/current/static/hot-standby.html#HOT-STANDBY-CONFLICT
John DeSoi, Ph.D.