pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Simon Riggs <simon@2ndQuadrant.com>
To: jd@commandprompt.com
Cc: Mark Steben <msteben@autorevenue.com>
Cc: 'Kevin Grittner' <Kevin.Grittner@wicourts.gov>
Cc: pgsql-admin@postgresql.org
Subject: Re: Warm Standby - log shipping
Date: Fri, 19 Dec 2008 17:12:05 +0000
Message-ID: <1229706725.4793.556.camel@ebony.2ndQuadrant> (raw)
In-Reply-To: <1229705491.9383.15.camel@jd-laptop.pragmaticzealot.org>
References: <D52D639EA1DC422DA3807EB17AF72239@dei26g028534>
	<494A7819.EE98.0025.0@wicourts.gov>
	<ABFD5C0414FC4B6D854F19376CEBC3E6@dei26g028534>
	<1229705491.9383.15.camel@jd-laptop.pragmaticzealot.org>


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




view thread (10+ messages)  latest in thread

Message-ID: <1229706725.4793.556.camel@ebony.2ndQuadrant>
Permalink:  ../1229706725.4793.556.camel@ebony.2ndQuadrant/
Also on:    postgresql.org/message-id/1229706725.4793.556.camel@ebony.2ndQuadrant

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: simon@2ndQuadrant.com, jd@commandprompt.com, msteben@autorevenue.com, Kevin.Grittner@wicourts.gov
  Subject: Re: Warm Standby - log shipping
  In-Reply-To: <1229706725.4793.556.camel@ebony.2ndQuadrant>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox