Is it possible to use the
archive_command to send to multiple machines? Is it just as simple as separating with a
&& since it is essentially just a command line?
command1 && command2
I assume this could have a bad effect if one command failed, for example if
command1 failed then
command2 wouldn't run; and if
command2 failed it would return non-zero for the whole thing and Postgres would re-try to send the WAL which would mean it would re-run
I am hoping there is a more official solution to the problem. My goal is to have one backup inside the data center, and one backup outside the data center.