Active-Passive DB

[rutuparna andhare]

Hi PG,
     In PG , can we have Active1 , Passive1 , Passive2 cluster.
Now all active1 data is present in passive1 and 2.
but when any delete query runs on active1 , same should get replicated on
passive1 But delete should not get triggered on passive2.

so passive2 can be used as archival db.
if active1 fails then , passive1 will become active2.

Thanks
Rutu