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'
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 |