Subject: Re: Logical Replication in Postgres 10.4
To: pgsql-admin@lists.postgresql.org
References: <1533877563199-0.post@n3.nabble.com>
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Message-ID: <108d3ba4-5a0b-b67c-17eb-4de71124e7df@matrix.gatewaynet.com>
Date: Fri, 10 Aug 2018 09:42:37 +0300
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:52.0) Gecko/20100101
 Thunderbird/52.6.0
MIME-Version: 1.0
In-Reply-To: <1533877563199-0.post@n3.nabble.com>
Content-Type: multipart/alternative;
 boundary="------------BF471EDB46E37D50F9D9EC4C"
Content-Language: en-US
Precedence: bulk

This is a multi-part message in MIME format.
--------------BF471EDB46E37D50F9D9EC4C
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

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


--------------BF471EDB46E37D50F9D9EC4C
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">On 10/08/2018 08:06, pavan95 wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:1533877563199-0.post@n3.nabble.com">
      <pre wrap="">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 &amp; 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!!!
</pre>
    </blockquote>
    Did you refresh the subscription ? :<br>
    <pre class="synopsis">ALTER SUBSCRIPTION <em class="replaceable"><code>name</code></em> REFRESH PUBLICATION <span style="font-size:11pt;font-family:Arial;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre;white-space:pre-wrap;" id="docs-internal-guid-1c8db871-7fff-8a50-c80d-04d1065a97bc">WITH ( COPY_DATA );</span></pre>
    <blockquote type="cite"
      cite="mid:1533877563199-0.post@n3.nabble.com">
      <pre wrap="">
Thanks in Advance!

Regards,
Pavan


--
Sent from: <a class="moz-txt-link-freetext" href="http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html">http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html</a>

</pre>
    </blockquote>
    <p><br>
    </p>
    <pre class="moz-signature" cols="200">-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt</pre>
  </body>
</html>

--------------BF471EDB46E37D50F9D9EC4C--