On 21 December 2015 at 22:57, Amit Bondwal <bondwal.a...@gmail.com> wrote:
> Hi Everyone, > > I am trying to setup three node bdr cluster, I am following the quick > start guide, > It is working well between first and 2nd node, but When I try to add 3rd > node, it give the below error. > > hakuna=# SELECT bdr.bdr_group_join( > local_node_name := 'node3', > node_external_dsn := 'host=pg3 port=5432 dbname=hakuna', > join_using_dsn := 'host=pg1 port=5432 dbname=hakuna' > ); > 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 > (6229651217067355961,1,17161) but the local node is > (6229649404569370556,1,19247) > Huh. That's interesting. The dsn '<empty string>'. How'd we get there? Can you show the output of select * from bdr.bdr_nodes; select * from bdr.bdr_connections; on the new node you're trying to join? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
