Re: Differential backup - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: Differential backup
Date
Msg-id 4BD6C9610200002500030F6C@gw.wicourts.gov
Whole thread Raw
In response to Re: Differential backup  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
Merlin Moncure <mmoncure@gmail.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


pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Differential backup
Next
From: Heikki Linnakangas
Date:
Subject: Re: Wierd quirk of HS/SR, probably not fixable