BDR table level replication questions

From: Dennis <dennisr(at)visi(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: BDR table level replication questions
Date: 2015-05-14 20:26:45
Message-ID: E3F2AC74-22CD-4F76-8D65-8D5C1A2DC854@visi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I am trying to setup table level replication with BDR 0.9.0 but I am running into some errors. I believe I must be missing a step or two in the process.

I currently have a two node group that I want to build.

1) On node1 I have a database built with the tables I want to replicate; table1, table2, table3.
2) On node2 I have created the database to hold the tables (just issued a create database statement) but no other objects have been added on node2.
3) On node1 I have issued the following commands without error:

SELECT bdr.bdr_group_create(
local_node_name := 'node1',
node_external_dsn := 'port=5432 dbname=apimgtdb user=postgres password=XXXX host=10.0.0.0.101',
replication_sets := ARRAY['test_rep_set']
);

SELECT bdr.bdr_node_join_wait_for_ready();

4) On node2 I then issue the following to join the group with out error:

SELECT bdr.bdr_group_join(
local_node_name := 'node2',
node_external_dsn := 'port=5432 dbname=apimgtdb user=postgres password=XXXX host=10.0.0.102',
join_using_dsn:= 'port=5432 dbname=apimgtdb user=postgres password=PostAlign host=10.0.0.101',
replication_sets := ARRAY[’test_rep_set']
);

5) On node2, if I then issue;

SELECT bdr.bdr_node_join_wait_for_ready();
the command just hangs. So I killed the command

6) Back on node1, I issue the command and receive an error:

select bdr.table_set_replication_sets(’table1', ARRAY[’test_rep_set'])
;
ERROR: No peer nodes or peer node count unknown, cannot acquire DDL lock
HINT: BDR is probably still starting up, wait a while
CONTEXT: SQL statement "SECURITY LABEL FOR bdr ON TABLE table1 IS '{ "sets" : [“test_rep_set"] }'"
PL/pgSQL function bdr.table_set_replication_sets(regclass,text[]) line 30 at EXECUTE statement

What am I missing? How are the steps different from setting database replication?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2015-05-14 20:31:58 Re: client_min_messages documentation typo
Previous Message David G. Johnston 2015-05-14 20:16:31 Re: Grouping By Similarity (using pg_trgm)?