BDR Across Distributed Nodes

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

Responses

Browse pgsql-general by date

  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