From: | Christian Vazquez <christian_vazquez(at)hotmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Remove Node BDR status kill |
Date: | 2015-03-31 19:49:21 |
Message-ID: | 1427831361027-5844154.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Felipe Santos | 2015-03-31 19:53:29 | Re: Catalog permissions |
Previous Message | BRUNO CESAR BERNARDES | 2015-03-31 19:44:04 | Re: Catalog permissions |