BDR Multiple database

Hi,

Please note that hackers is not the right list for this; it's for
development discussions. Please ask such questions on -general.

On 2015-02-26 17:46:55 +0700, Jirayut Nimsaeng wrote:

We want to use BDR with multiple database but now all the document didn't
show any example how to config BDR with multiple database. We've tried with
many combination as below but still no luck. Anyone can point us this?

1st combination

bdr.connections = 'bdrnode02db1'
bdr.bdrnode02db1_dsn = 'dbname=db1 host=172.17.42.1 port=49264
user=postgres'
bdr.connections = 'bdrnode02db2'
bdr.bdrnode02db2_dsn = 'dbname=db2 host=172.17.42.1 port=49264
user=postgres'

bdr.connections needs to contain a list of all connections, not
individual ones. E.g.
bdr.connections = 'bdrnode02db1, bdrnode02db2'

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Thank you so much for clarification about list room for discussion and
suggestion
Now I can do BDR multiple database with this configuration

bdr.connections = 'bdrnode02db1, bdrnode02db2'
bdr.bdrnode02db1 = 'dbname=db1 host=172.17.42.1 port=49319 user=postgres'
bdr.bdrnode02db2 = 'dbname=db2 host=172.17.42.1 port=49319 user=postgres'

Regards,
Jirayut

On Thu, Feb 26, 2015 at 6:12 PM, Andres Freund <andres@2ndquadrant.com>
wrote: