On Fri, 2019-11-22 at 14:25 +0530, rutuparna andhare wrote: > 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.
You would need logical replication for passive2. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
