Postgres Pro
Downloads
Home   >   mailing lists

Thread: Active-Passive DB

Active-Passive DB

From
rutuparna andhare
Date:
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

Re: Active-Passive DB

From
Laurenz Albe
Date:
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
triggeredon 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