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 по дате отправления: