Re: Fwd: Reversing flow of WAL shipping - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Fwd: Reversing flow of WAL shipping
Date
Msg-id 4AE05317020000250002BDE8@gw.wicourts.gov
Whole thread Raw
In response to Re: Fwd: Reversing flow of WAL shipping  (David Jantzen <djantzen@ql2.com>)
List pgsql-admin
David Jantzen <djantzen@ql2.com> wrote:

> Thanks for the quick response Joshua, much appreciated.  Is there
> any way to avoid or minimize a period without a warm standby when I
> switch to Server B for production?  What about rsyncing the data
> directory from Server B to Server C after B goes live?

In my experience, proper use of rsync just before the switch, combined
with use of rsync as your PITR base backup technique, can make for a
very short period without warm standby.

-Kevin

pgsql-admin by date:

Previous
From: Scott Mead
Date:
Subject: Re: Fwd: Reversing flow of WAL shipping
Next
From: "Eric Comeau"
Date:
Subject: Increasing the length of a VARCHAR column without table rewrite