bdr_init_copy ends fine but doesn't copy the remote db

From: Emrah Tema <emrahtema(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: bdr_init_copy ends fine but doesn't copy the remote db
Date: 2020-06-29 05:11:23
Message-ID: CAFwWTi0T8a_ss6KMW2nVCvD=-vicJRVD9q6XzzNGpNdoQQ1HjA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am trying to make a multi-master replication using BDR and because of the
DDL issues-errors, I decided to use bdr_init_copy command instead of using
bdr.bdr_group_join(). I have two servers with PostgreSQL services and one
of them(Master2) has an empty DB, the other(Master1) has one schema and one
table on its DB. When I try to run bdr_init_copy command, everything goes
well and the last rows of the output are these:

.....
Initializing BDR on the local node:
bdrdemo: adding the database to BDR cluster ...All done

But when I check, the schema and the table on the Master1 is not copied to
Master2. Master2's database is still empty. What could have gone wrong? The
bdr_init_copy that I used is:

./bdr_init_copy -D /var/lib/pgsql/9.4-bdr/data -n node2 -d
'host=10.m1.m1.m1 port=5598 dbname=bdrdemo' -U postgres
--local-dbname='host=10.m2.m2.m2 port=5598 dbname=bdrdemo'

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2020-06-29 07:33:20 Re: Postgresql HA Cluster
Previous Message Peter J. Holzer 2020-06-28 21:55:50 Re: n_distinct off by a factor of 1000