Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> Your archiving requirements are high.
They are set by a Steering Committee composed of the Directory of
State Courts and various District Court Administrators, Judges,
Clerks of Court, and Registers in Probate who rely on this data and
*really* want to be safe. I just work here. ;-)
> With the new stuff (HS/SR) taken into consideration, would you
> have done your DR the same way if you had to do it all over again?
When SR is available, if I can maintain the flow of WAL files while
doing so, I would feed our "warm standby" farm with SR connections.
Otherwise I'd do the same. It's pretty much mandated that we keep
those copies. It'd be ideal if SR could reconstruct the WAL file
segments on the receiving end, to avoid sending the data twice.
Dare I dream? :-)
-Kevin