Active-Passive DB

From: rutuparna andhare <rsandhare(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Active-Passive DB
Date: 2019-11-22 08:55:59
Message-ID: CADND9y72nYrH4EuGB-NxHsT3FjMohyBE7a8DxwQjU7crhvS1pw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2019-11-22 08:59:43 Re: Active-Passive DB
Previous Message Michael Paquier 2019-11-22 07:27:09 Re: ON COMMIT options for non temporary tables