From: | Florin Andrei <florin(at)andrei(dot)myip(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | BDR: cannot remove node from group |
Date: | 2015-08-25 23:19:51 |
Message-ID: | 2e513b7911a1e4f692b85f0b0246ab59@andrei.myip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Testing BDR for the first time, using the binary packages for Ubuntu
10.04 provided at http://packages.2ndquadrant.com/bdr/apt/
Postgres 9.4.4 and BDR 0.9.2 (I think)
I'm loosely following this document:
http://bdr-project.org/docs/stable/quickstart-enabling.html
Except I've created two separate instances and I'm trying to replicate
between instances.
I've created the bdrdemo database, and then I've created the extensions:
CREATE EXTENSION btree_gist;
CREATE EXTENSION bdr;
Then I did bdr_group_create on one node:
SELECT bdr.bdr_group_create(
local_node_name := 'pg-test1-dev-uswest2-aws',
node_external_dsn := 'port=5432 dbname=bdrdemo'
);
But then I've realized I need a host statement in node_external_dsn. So
now I'm trying to remove this node:
SELECT bdr.bdr_part_by_node_names('{pg-test1-dev-uswest2-aws}');
But if I try to re-add it with the new parameters:
SELECT bdr.bdr_group_create(
local_node_name := 'pg-test1-dev-uswest2-aws',
node_external_dsn := 'host=pg-test1-dev-uswest2-aws port=5432
dbname=bdrdemo'
);
I get this:
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
What do I need to do to start over? I want to delete all traces of the
BDR configuration I've done so far.
--
Florin Andrei
http://florin.myip.org/
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2015-08-25 23:20:00 | Re: PostgreSQL Developer Best Practices |
Previous Message | Rob Sargent | 2015-08-25 23:12:48 | Re: PostgreSQL Developer Best Practices |