pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRemove Node BDR status kill
3+ messages / 2 participants
[nested] [flat]
* Remove Node BDR status kill
@ 2015-03-31 19:49 Christian Vazquez <christian_vazquez@hotmail.com>
2015-04-06 21:23 ` Re: Remove Node BDR status kill Andres Freund <andres@anarazel.de>
0 siblings, 1 reply; 3+ messages in thread
From: Christian Vazquez @ 2015-03-31 19:49 UTC (permalink / raw)
To: 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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Remove Node BDR status kill
2015-03-31 19:49 Remove Node BDR status kill Christian Vazquez <christian_vazquez@hotmail.com>
@ 2015-04-06 21:23 ` Andres Freund <andres@anarazel.de>
2015-04-06 21:56 ` Re: Remove Node BDR status kill Christian Vazquez <christian_vazquez@hotmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Andres Freund @ 2015-04-06 21:23 UTC (permalink / raw)
To: Christian Vazquez <christian_vazquez@hotmail.com>; +Cc: pgsql-admin
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Remove Node BDR status kill
2015-03-31 19:49 Remove Node BDR status kill Christian Vazquez <christian_vazquez@hotmail.com>
2015-04-06 21:23 ` Re: Remove Node BDR status kill Andres Freund <andres@anarazel.de>
@ 2015-04-06 21:56 ` Christian Vazquez <christian_vazquez@hotmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Christian Vazquez @ 2015-04-06 21:56 UTC (permalink / raw)
To: pgsql-admin
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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2015-04-06 21:56 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-03-31 19:49 Remove Node BDR status kill Christian Vazquez <christian_vazquez@hotmail.com>
2015-04-06 21:23 ` Andres Freund <andres@anarazel.de>
2015-04-06 21:56 ` Christian Vazquez <christian_vazquez@hotmail.com>
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