Postgres Pro
Downloads
Home   >   mailing lists

Thread: PostgreSQL HA

PostgreSQL HA

From
venkata786 k
Date:
Hi Team,

Could you please share postgresql's best active(R/W)-active(R/W) (multi master replication) solutions.
My Team is thinking about implementing active-active replacing master-slave.

Regards,
Venkat





Virus-free. www.avast.com

Re: PostgreSQL HA

From
Ganesh Korde
Date:
You can go for BDR from 2nd Quadrant.

On Sat, 26 Dec 2020, 4:17 pm venkata786 k, <venkata.k786@gmail.com> wrote:
Hi Team,

Could you please share postgresql's best active(R/W)-active(R/W) (multi master replication) solutions.
My Team is thinking about implementing active-active replacing master-slave.

Regards,
Venkat





Virus-free. www.avast.com

Re: PostgreSQL HA

From
Atul Kumar
Date:
Use xdb, simpler and better

On Saturday, December 26, 2020, venkata786 k <venkata.k786@gmail.com> wrote:
Hi Team,

Could you please share postgresql's best active(R/W)-active(R/W) (multi master replication) solutions.
My Team is thinking about implementing active-active replacing master-slave.

Regards,
Venkat





Virus-free. www.avast.com

Re: PostgreSQL HA

From
venkata786 k
Date:
Hi Ganesh,

BDR supports postgres 12 & 13 versions ??
I think we have BDR compatible for 9.4 postgres.
Could you plz confirm.


On Sat, 26 Dec 2020 at 16:22, Ganesh Korde <ganeshakorde@gmail.com> wrote:
You can go for BDR from 2nd Quadrant.

On Sat, 26 Dec 2020, 4:17 pm venkata786 k, <venkata.k786@gmail.com> wrote:
Hi Team,

Could you please share postgresql's best active(R/W)-active(R/W) (multi master replication) solutions.
My Team is thinking about implementing active-active replacing master-slave.

Regards,
Venkat





Virus-free. www.avast.com

Re: PostgreSQL HA

From
venkata786 k
Date:
Hi Ganesh,

I saw symmetric DS in Google.
Are there any disadvantages with symmetric DS?



Virus-free. www.avast.com

On Sat, 26 Dec 2020 at 16:22, Ganesh Korde <ganeshakorde@gmail.com> wrote:
You can go for BDR from 2nd Quadrant.

On Sat, 26 Dec 2020, 4:17 pm venkata786 k, <venkata.k786@gmail.com> wrote:
Hi Team,

Could you please share postgresql's best active(R/W)-active(R/W) (multi master replication) solutions.
My Team is thinking about implementing active-active replacing master-slave.

Regards,
Venkat





Virus-free. www.avast.com

Re: PostgreSQL HA

From
Jehan-Guillaume de Rorthais
Date:
On Sat, 26 Dec 2020 05:51:22 +0530
venkata786 k <venkata.k786@gmail.com> wrote:

> Hi Team,
> 
> Could you please share postgresql's best active(R/W)-active(R/W) (multi
> master replication) solutions.
> My Team is thinking about implementing active-active replacing master-slave.

Symmetric replication bring a lot of complexity in various layers:
application, architecture, backups.

Why do you need symmetric replication? Do you have any issues with asymmetric
replication?

Re: PostgreSQL HA

From
Andreas Kretschmer
Date:

Am 26.12.20 um 17:20 schrieb venkata786 k:
> Hi Ganesh,
>
> BDR supports postgres 12 & 13 versions ??
> I think we have BDR compatible for 9.4 postgres.
> Could you plz confirm.

That's true. PG 9.4 is out of support.



Regards, Andreas

-- 
2ndQuadrant, an EDB company
www.2ndQuadrant.com / www.enterprisedb.com