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