Re: Cascading Recovery

[Ashish Nauriyal <ashish.nauriyal@xxxxxxxxxxxxxxxx>]

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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin