From: Christian Vazquez <christian_vazquez@hotmail.com>
To: pgsql-admin@postgresql.org
Subject: Remove Node BDR status kill
Date: Tue, 31 Mar 2015 12:49:21 -0700 (MST)
Message-ID: <1427831361027-5844154.post@n5.nabble.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: christian_vazquez@hotmail.com
Subject: Re: Remove Node BDR status kill
In-Reply-To: <1427831361027-5844154.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox