From: | Ashish Nauriyal <ashish(dot)nauriyal(at)enterprisedb(dot)com> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | Selva manickaraja <mavles78(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Cascading Recovery |
Date: | 2011-02-11 08:17:15 |
Message-ID: | AANLkTimb+A9AaxN4OmT6uVzFAXGsH9KDbOykNnCq7_B5@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Can be achieved using Slony and called cascaded subscription of sets.
Ashish,
EnterpriseDB Corp.
The Enterprise PostgreSQL Company
On Fri, Feb 11, 2011 at 1:05 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)info>wrote:
> Le 11/02/2011 05:43, Selva manickaraja a écrit :
> > We are considering on using a primary and 2 secondary machines. But our
> plan
> > is to cascade the recovery as follows:
> >
> > 1. Primary Machine-A (read and write operation)
> > 2. Secondary Machine-B (recover from Machine A)
> > 3. Secondary Machine-C (recover from Machine B)
> >
> > We are planning this kind of recovery as we want to phase out recovery
> > interval between C and B 30 minutes.
> >
> > Can this be achieved by PostgreSQL.
> >
>
> Not with Streaming Replication. But you can achieve this with a
> different replication engine, like Slony.
>
>
> --
> Guillaume
> http://www.postgresql.fr
> http://dalibo.com
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
From | Date | Subject | |
---|---|---|---|
Next Message | Stefanie Weykam | 2011-02-11 11:33:41 | pdAdmin uninstall - how to get rid of temp files? |
Previous Message | Guillaume Lelarge | 2011-02-11 07:35:02 | Re: Cascading Recovery |