Re: Warm Standby - log shipping - Mailing list pgsql-admin

From Mark Steben
Subject Re: Warm Standby - log shipping
Date
Msg-id B2F617BC893F4BD38D30BCA5270A1BB2@dei26g028534
Whole thread Raw
In response to Re: Warm Standby - log shipping  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Thanks for the clarifications Kevin, Josh, Simon
I am trying out Kevin's suggestion to create a second standby copy now.
I know I have to create the base copy and send it over, at least
For the first time to start recovery. I will look at rsync to do that.

Thanks for all the help -- Mark


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


pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Warm Standby - log shipping
Next
From: "Lipker, Joseph"
Date:
Subject: Migration \ OID question