From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Logical Replication in Postgres 10.4
Date: Fri, 10 Aug 2018 09:42:37 +0300
Message-ID: <108d3ba4-5a0b-b67c-17eb-4de71124e7df@matrix.gatewaynet.com> (raw)
In-Reply-To: <1533877563199-0.post@n3.nabble.com>
References: <1533877563199-0.post@n3.nabble.com>
On 10/08/2018 08:06, pavan95 wrote:
> 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!!!
Did you refresh the subscription ? :
ALTER SUBSCRIPTION/|name|/ REFRESH PUBLICATIONWITH ( COPY_DATA );
> Thanks in Advance!
>
> Regards,
> Pavan
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
>
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
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: achill@matrix.gatewaynet.com, pgsql-admin@lists.postgresql.org
Subject: Re: Logical Replication in Postgres 10.4
In-Reply-To: <108d3ba4-5a0b-b67c-17eb-4de71124e7df@matrix.gatewaynet.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