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