Re: Warm Standby - log shipping

On Fri, 2008-12-19 at 08:51 -0800, Joshua D. Drake wrote:
> On Fri, 2008-12-19 at 09:14 -0500, Mark Steben wrote:
> > What I'm hearing is that I have to perform a base backup on my master in
> > Mass. after recovery completes, send that over a secure network
> > To Virginia, and lay it down there.  Simple enough but the time to travel
> > Over the network becomes an issue - 12 - 13 hours at best.
> > If we have to do this then we will.  I just want to make sure I'm
> > understanding your advice.
>
> Yes.

Yes, but use rsync, so you don't need to wait for 13 hours.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support