Postgres Pro
Downloads
Home   >   mailing lists

BDR Multiple database - Mailing list pgsql-hackers

From Jirayut Nimsaeng
Subject BDR Multiple database
Date
Msg-id CACbDkQODA+irU_UmVMqjFaNkc2hxQ1JbLWvq5=FaeW8EwFaWQQ@mail.gmail.com
Whole thread Raw
List pgsql-hackers
Tree view
Hi all,

I'm using PostgreSQL BDR 9.4.1 to test BDR capability right now

$ psql --version
psql (PostgreSQL) 9.4.1

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'


2nd combination

bdr.connections = 'bdrnode02'
bdr.bdrnode02_dsn = 'dbname=db1 host=172.17.42.1 port=49264 user=postgres'
bdr.bdrnode02_dsn = 'dbname=db2 host=172.17.42.1 port=49264 user=postgres'


Regards,
Jirayut

pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: How about to have relnamespace and relrole?
Next
From: Michael Paquier
Date:
Subject: Re: Bug in pg_dump