From: pavan95 <pavan.postgresdba@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Logical Replication in Postgres 10.4
Date: Thu, 9 Aug 2018 22:06:03 -0700 (MST)
Message-ID: <1533877563199-0.post@n3.nabble.com> (raw)
Hi all,
I have a doubt in Logical Replication feature in 10.4. I have 2 servers
where in which I have configured "Logical Replication" between two databases
source and destination.
*In the Source*:
Before creating publication on publisher I have create 2 tables on both
publisher & subscriber. But only publisher contains data.
Later, I have create publication for all tables using the below command:
CREATE PUBLICATION mypub FOR ALL TABLES;
*In the Target*:
In the subscriber server, I have created a subscription for that
publication.
Suddenly within no time the data got replicated(happy for that).
The actual problem now aroused. I again went on creating a new table on the
primary but it was not part of my publication(surprised). So it was not
replicated.
But from the documentation "FOR ALL TABLES" option the futurely created
tables are also part of the replication which was not (3'rd table) in my
case.
What went wrong? Kindly help me out!!!
Thanks in Advance!
Regards,
Pavan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pavan.postgresdba@gmail.com
Subject: Re: Logical Replication in Postgres 10.4
In-Reply-To: <1533877563199-0.post@n3.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox