From: | Amit Bondwal <bondwal(dot)amit(at)gmail(dot)com> |
---|---|
To: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | BDR error while adding 3rd node to cluster |
Date: | 2015-12-21 14:57:32 |
Message-ID: | CAJ=k2iHVfR7Opbof3O-uvP-fk_+5Svhpp+jMGzkpJFckou5pyw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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)
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
I tried to delete database on 3rd node and recreate it but same error. I
also tried to connect to 2nd node as external dsn but same error.
I am able to access all three nodes to each other using psql.
--
Regards
Amit Bondwal
From | Date | Subject | |
---|---|---|---|
Next Message | oleg yusim | 2015-12-21 16:38:15 | Re: Session Identifiers |
Previous Message | Bill Moran | 2015-12-21 14:22:18 | Re: Test disk reliability (or HGST HTS721010A9E630 surprisingly reliable) |