BDR: cannot remove node from group

Поиск
Список
Период
Сортировка
От Florin Andrei
Тема BDR: cannot remove node from group
Дата
Msg-id 2e513b7911a1e4f692b85f0b0246ab59@andrei.myip.org
обсуждение исходный текст
Ответы Re: BDR: cannot remove node from group
Список 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/


В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: PostgreSQL Developer Best Practices
Следующее
От: Jerry Sievers
Дата:
Сообщение: Re: PostgreSQL Developer Best Practices