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.