Active-Passive DB - Mailing list pgsql-general

From rutuparna andhare
Subject Active-Passive DB
Date
Msg-id CADND9y72nYrH4EuGB-NxHsT3FjMohyBE7a8DxwQjU7crhvS1pw@mail.gmail.com
Whole thread Raw
Responses Re: Active-Passive DB  (Laurenz Albe <laurenz.albe@cybertec.at>)
List 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

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: ON COMMIT options for non temporary tables
Next
From: Laurenz Albe
Date:
Subject: Re: Active-Passive DB