From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Mark Steben <msteben@autorevenue.com>
To: pgsql-admin@postgresql.org
Subject: Re: Warm Standby - log shipping
Date: Fri, 19 Dec 2008 11:35:50 -0600
Message-ID: <494B8716.EE98.0025.0@wicourts.gov> (raw)
In-Reply-To: <ABFD5C0414FC4B6D854F19376CEBC3E6@dei26g028534>
References: <D52D639EA1DC422DA3807EB17AF72239@dei26g028534>
<494A7819.EE98.0025.0@wicourts.gov>
<ABFD5C0414FC4B6D854F19376CEBC3E6@dei26g028534>
>>> "Mark Steben" <msteben@autorevenue.com> 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.
I'm not sure we're understanding each other. I was suggesting that
you needed to make a new base backup in Mass. and send it to Virginia.
Recovery doesn't start until you get that. There is one way you
might avoid that, though -- if you saved a copy of the original base
backup and all WAL files since then you could start over and roll all
the way to current.
> Simple enough but the time to travel
> Over the network becomes an issue - 12 - 13 hours at best.
As already suggested, if you're not using rsync with a daemon, you
should look at that. For us, at least, it typically cuts the copy
time by an order of magnitude.
If you have the room and follow the advice given in my previous post,
your warm standby should never come out of recovery mode. You can
stop and start the server without that happening. What I was
suggesting was that you periodically (daily?) you stop the warm
standby in Virginia, copy the data directory to another location,
restart the warm standby in recovery mode, then start up the copy of
the warm standby in recovery mode, take that out of recovery mode, and
use it for your reports.
-Kevin
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: Kevin.Grittner@wicourts.gov, msteben@autorevenue.com
Subject: Re: Warm Standby - log shipping
In-Reply-To: <494B8716.EE98.0025.0@wicourts.gov>
* 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