Clarification related to BDR

2020-05-14 Thread Santhosh Kumar
Hi, I came across a link published in postgresql, where it is clearly mentioned BDR as an open source. When I tried to install BDR for CentOS from 2ndQuadrant, the yum repository was not reachable and upon further enquiring with 2ndQuadrant, I got a reply from them quoting as follows "BDR is not

Configuring more than one hot standby server

2020-05-19 Thread Santhosh Kumar
Hi Community, I read about "hot stand by" server and as far as the document goes, it does not explicitly explain about, whether is it possible to configure more than on database as a Hot stand by server. If we can configure more than one hot stand by server, which database will take the role of

Clarification relation logical replication

2020-05-19 Thread Santhosh Kumar
Hi, Can I have a cluster of multiple instances with logical replication enabled for all tables with every single instance as both publisher and subscriber, to mimic multi master replication? The documentation says, care must be taken on subscribed publication objects to not overlap? Ref :

Behaviour of failed Primary

2020-05-21 Thread Santhosh Kumar
Hi Forum, If I have a cluster with Synchronous replication enabled with three nodes, for eg: [primary] [hot stand by 1] [host stand by 2] And for some unforeseen reasons, if primary fails, the failover will kick in and hot stand by 1 will become new primary and cluster setup will look like