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
