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

From Greg Stark
Subject Re: Fwd: Reversing flow of WAL shipping
Date
Msg-id 407d949e0910221120w141a458l809b54d8250432e2@mail.gmail.com
Whole thread Raw
List pgsql-hackers
[moving to pgsql-hackers]

On Thu, Oct 22, 2009 at 10:28 AM, 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?

This is definitely something that needs to be addressed in future
versions of Postgres, especially once we have Hot
Standby/Read-Only-Slaves and Sync-Replication. People will want to
have dozens of active slaves and rebuilding them all every time a
failover happens will be unbearable. Not to mention that in the
meantime they have to live with no redundancy.


--
greg


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: EvalPlanQual seems a tad broken
Next
From: Josh Berkus
Date:
Subject: Re: per table random-page-cost?