On 4 March 2016 at 23:02, Alvaro Aguayo Garcia-Rada <aaguayo@xxxxxxxxxxxxxxx> wrote:
Hi. I currently have two servers in different geographical locations; both of them are replicating with Postgres-BDR, that's OK. However, I need two more servers to get a read only replication of only some tables from the master ones.
At first I tried with Slony, but it just didn't work(don't know why). I've also checked docs for UDR and pglogical, but don't keep it clear if they can coexist with BDR.
pglogical should theoretically work as both provider and subscriber on BDR, but we haven't put the test infrastructure together to validate that and make it an officially supported configuration yet. It's certainly desired and on the roadmap.
Using UDR with BDR doesn't work well; the issues we found there are part of why pglogical was created and why it works the way it does.
