postgresql-9.4-BDR replication issue
От | Mikhail Levandovskiy |
---|---|
Тема | postgresql-9.4-BDR replication issue |
Дата | |
Msg-id | 5562FEAB.1040903@nixsolutions.com обсуждение исходный текст |
Ответы |
Re: postgresql-9.4-BDR replication issue
|
Список | pgsql-admin |
Hi all. I've installed postgresql-9.4 with BDR from its official repository, and trying to create replication group with database on two nodes: on first node runned: CREATE EXTENSION btree_gist; CREATE EXTENSION bdr; SELECT bdr.bdr_group_create(local_node_name := 'node1', node_external_dsn := 'host=10.10.1.39 dbname=bdrdemo2'); on second node runned: CREATE EXTENSION btree_gist; CREATE EXTENSION bdr; SELECT bdr.bdr_group_join(local_node_name := 'node2', node_external_dsn := 'host=10.10.5.107 dbname=bdrdemo2', join_using_dsn := 'host=10.10.1.39 dbname=bdrdemo2' ); And then getting this error on second node: < 2015-05-25 03:38:37.714 PDT >LOG: starting background worker process "bdr db: bdrdemo" < 2015-05-25 03:38:37.731 PDT >ERROR: previous init failed, manual cleanup is required < 2015-05-25 03:38:37.731 PDT >DETAIL: Found bdr.bdr_nodes entry for bdr (6152755282451262703,1,16407,) with state=i in remote bdr.bdr_nodes < 2015-05-25 03:38:37.731 PDT >HINT: Remove all replication identifiers and slots corresponding to this node from the init target node then drop and recreate this database and try again < 2015-05-25 03:38:37.732 PDT >LOG: worker process: bdr db: bdrdemo (PID 25402) exited with exit code 1 I've tried to remove all replication slots on both nodes: select * from pg_replication_slots; select pg_drop_replication_slot('replication_slot_name'); tried to clean bdr.bdr_nodes, bdr.bdr_node_slots and bdr.bdr_connections, tried to drop database and create it again - all was useless. What's missed? Thanks.
В списке pgsql-admin по дате отправления: