From: | billythebomber <billythebomber(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | BDR Across Distributed Nodes |
Date: | 2015-04-23 18:42:59 |
Message-ID: | CALdZh8b7oYiLEe+jxJNziScBwJVai58Q8h72=uLqoOQj5iCvTA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm starting to test BDR, and I've followed the quickstart included in the
documentation successfully.
The problem I'm encountering is when two servers are on different hosts,
which is not covered in the documentation. Node1 is 10.0.0.1, node2 is
10.0.0.2, but when I try to connect from node2:
demo=# SELECT bdr.bdr_group_join(
local_node_name := 'node2',
node_external_dsn := 'port=5432 dbname=demo',
join_using_dsn := 'port=5432 dbname=demo host=10.0.0.1'
ERROR: node identity for node_external_dsn does not match current node
when connecting back via remote
DETAIL: The dsn '' connects to a node with identity
(6140654556124456820,1,16385) but the local node is
(6140654709151998583,1,16385)
HINT: The 'node_external_dsn' parameter must refer to the node you're
running this function from, from the perspective of the node pointed to by
join_using_dsn
If I add node2 host entry:
demo=# SELECT bdr.bdr_group_join(
local_node_name := 'node2',
node_external_dsn := 'port=5432 dbname=demo host=10.0.0.2',
join_using_dsn := 'port=5432 dbname=demo host=10.0.0.1'
);
FATAL: could not connect to the server in non-replication mode: could not
connect to server: Connection refused
Is the server running on host "10.0.0.2" and accepting
TCP/IP connections on port 5432?
DETAIL: dsn was: port=5432 dbname=demo host=10.0.0.2
fallback_application_name='bdr (6140654709151998583,1,16385,):bdrnodeinfo'
justgive=# select bdr.bdr_version();
bdr_version
--------------------------
0.9.0-2015-03-24-f36ee65
(1 row)
Does anybody happen to have any examples of calling bdr.bdr_group_join when
there are remote IPs involved?
- Billy
From | Date | Subject | |
---|---|---|---|
Next Message | Marc-André Goderre | 2015-04-23 19:55:25 | Invalid memory alloc |
Previous Message | Raymond O'Donnell | 2015-04-23 18:12:52 | Re: Moving Specific Data Across Schemas Including FKs |