Thread: Remove Node BDR status kill

Remove Node BDR status kill

From
Christian Vazquez
Date:
Hi ,  i try to remove a node for recreate but is not possible :

master=# SELECT * FROM bdr.bdr_nodes;
-[ RECORD 1 ]------+------------------------
node_sysid         | 6131854951154377508
node_timeline      | 1
node_dboid         | 16387
node_status        | k
node_name          | master1
node_local_dsn     | port=5432 dbname=master
node_init_from_dsn |


The status node is kill


no have slots.


I remove the node with :

SELECT bdr.bdr_part_by_node_names('master1');


master=# SELECT bdr.bdr_group_create(
master(#       local_node_name := 'master1',
master(#       node_external_dsn := 'host=asusisv-pgsqlr1 dbname=master'
master(# );
ERROR:  This node is already a member of a BDR group
HINT:  Connect to the node you wish to add and run bdr_group_join from it
instead
CONTEXT:  SQL statement "SELECT bdr.internal_begin_join(
        'bdr_group_join',
        local_node_name,
        CASE WHEN node_local_dsn IS NULL THEN node_external_dsn ELSE
node_local_dsn END,
        join_using_dsn)"
PL/pgSQL function bdr_group_join(text,text,text,text,integer,text[]) line 21
at PERFORM
SQL statement "SELECT bdr.bdr_group_join(
        local_node_name := local_node_name,
        node_external_dsn := node_external_dsn,
        join_using_dsn := null,
        node_local_dsn := node_local_dsn,
        apply_delay := apply_delay,
        replication_sets := replication_sets)"
PL/pgSQL function bdr_group_create(text,text,text,integer,text[]) line 3 at
PERFORM


how remove and re add the node ?


Regards




-----
Christian Vazquez

--
View this message in context: http://postgresql.nabble.com/Remove-Node-BDR-status-kill-tp5844154.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


Re: Remove Node BDR status kill

From
Andres Freund
Date:
On 2015-03-31 12:49:21 -0700, Christian Vazquez wrote:
> how remove and re add the node ?

At the moment it's not officially supported to part and re-join one
node. It's not particularly hard to add support for it, it just wasn't a
priority so far.

Greetings,

Andres Freund


Re: Remove Node BDR status kill

From
Christian Vazquez
Date:
hi , thanks for the reply.  But why are in the status kill ? and remove in
permanent mode ?

Regards



-----
Christian Vazquez

--
View this message in context: http://postgresql.nabble.com/Remove-Node-BDR-status-kill-tp5844154p5844857.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.