Cascading Recovery

From: Selva manickaraja <mavles78(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Cascading Recovery
Date: 2011-02-11 04:43:10
Message-ID: AANLkTi=xpkueSAPHyiVWs+HAxGTWUa6hXZ49J9gT49NM@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Thank you.

Warmest Regards,

Selvam

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2011-02-11 07:35:02 Re: Cascading Recovery
Previous Message Keith Gabryelski 2011-02-11 02:59:16 Re: Is there a batch/bulk UPDATE syntax available?