Skip site navigation (1) Skip section navigation (2)

Re: Warm Standby - log shipping

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: jd(at)commandprompt(dot)com
Cc: Mark Steben <msteben(at)autorevenue(dot)com>, "'Kevin Grittner'" <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Warm Standby - log shipping
Date: 2008-12-19 17:12:05
Message-ID: 1229706725.4793.556.camel@ebony.2ndQuadrant (view raw or flat)
Thread:
Lists: pgsql-admin
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


In response to

pgsql-admin by date

Next:From: Kevin GrittnerDate: 2008-12-19 17:35:50
Subject: Re: Warm Standby - log shipping
Previous:From: Simon RiggsDate: 2008-12-19 17:11:26
Subject: Re: Warm Standby - log shipping

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group