On Tue, Dec 22, 2015 at 10:05 AM, Craig Ringer <cr...@2ndquadrant.com>
wrote:
> select * from bdr.bdr_connections;
>
Hi Craig, Thanks for your reply, These commands shows nothing on 3rd node.
*on node3:-*hakuna=# select * from bdr.bdr_nodes;
node_sysid | node_timeline | node_dboid | node_status | node_name |
node_local_dsn | node_init_from_dsn
------------+---------------+------------+-------------+-----------+----------------+--------------------
(0 rows)
conn_sysid | conn_timeline | conn_dboid | conn_origin_sysid |
conn_origin_timeline | conn_origin_dboid | conn_is_unidirectional |
conn_dsn | conn_apply_delay | conn_replication_sets
------------+---------------+------------+-------------------+----------------------+-------------------+------------------------+----------+------------------+-----------------------
(0 rows)
*on node1:-*
hakuna=# select * from bdr.bdr_nodes;
node_sysid | node_timeline | node_dboid | node_status | node_name
| node_local_dsn | node_init_from_dsn
---------------------+---------------+------------+-------------+-----------+----------------------------------+----------------------------------
6229651184159874988 | 1 | 18719 | r | node1
| host=pg1 port=5432 dbname=hakuna |
6229651217067355961 | 1 | 17161 | r | node2
| host=pg2 port=5432 dbname=hakuna | host=pg1 port=5432 dbname=hakuna
(2 rows)
It is conflicting with ID of node 2 as it shows output of above command on
node 1.
My OS is debian Jessie and I installed it from bdr repo. Current version of
bdr is 0.9.3
