BDR Cluster vs DB Config - Mailing list pgsql-general

From Jonathan Eastgate
Subject BDR Cluster vs DB Config
Date
Msg-id CAF0Mkq_3E89J14hVNFVpq0sjYdUw67v-=Z9dn3DfqhJROK-NUg@mail.gmail.com
Whole thread Raw
Responses Re: BDR Cluster vs DB Config
Re: BDR Cluster vs DB Config
List pgsql-general
Hi everyone.

We've been testing BDR on and off for the last 2 years and are keen to start looking at implementing it in production as it seems 0.93 has resolved most of the issues we faced with it in the early days.

However there is still one item that makes it a difficult proposition... 

DSN config per database.

Is there any way to configure BDR on a cluster wide basis so that all DB's on a cluster are replicated via BDR instead of having to configure a connection for each DB we want to replicate?

The problem we have is over 20 clusters with about 200 DB's per cluster and growing constantly so this would make deploying BDR a painful process - if we had to add a connection for each existing DB and then every new DB.

Is there a way around this or are there plans to make this type of config available?

Thanks in advance.
 
Jonathan J. Eastgate
Chief Technology Officer | simPRO Software Group
Ph: 1300 139 467    +61 7 3147 8777



Keep up to date with simPRO at: http://simprogroup.com/blog
The contents of this email are subject to our email disclaimer.


--

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Is it possible to control the location of the lock file when starting postgres?
Next
From: Alvaro Aguayo Garcia-Rada
Date:
Subject: Re: BDR Cluster vs DB Config