Search Postgresql Archives

Re: BDR error while adding 3rd node to cluster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Tue, Dec 22, 2015 at 10:05 AM, Craig Ringer <craig@xxxxxxxxxxxxxxx> 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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux