| From: | Jirayut Nimsaeng <jirayut(at)proteus-tech(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | BDR Multiple database |
| Date: | 2015-02-26 10:46:55 |
| Message-ID: | CACbDkQODA+irU_UmVMqjFaNkc2hxQ1JbLWvq5=FaeW8EwFaWQQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2015-02-26 11:12:35 | Re: [HACKERS] BDR Multiple database |
| Previous Message | Ramesh T | 2015-02-26 10:33:51 | rules |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2015-02-26 11:12:35 | Re: [HACKERS] BDR Multiple database |
| Previous Message | Kyotaro HORIGUCHI | 2015-02-26 10:34:37 | Re: How about to have relnamespace and relrole? |