pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Logical Replication in Postgres 10.4
6+ messages / 2 participants
[nested] [flat]
* Re: Logical Replication in Postgres 10.4
@ 2018-08-10 05:06 pavan95 <pavan.postgresdba@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: pavan95 @ 2018-08-10 05:06 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Logical Replication in Postgres 10.4
@ 2018-08-10 06:42 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: pavan95 <pavan.postgresdba@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Achilleas Mantzios @ 2018-08-10 06:42 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Logical Replication in Postgres 10.4
@ 2018-08-13 11:34 pavan95 <pavan.postgresdba@gmail.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 1 reply; 6+ messages in thread
From: pavan95 @ 2018-08-13 11:34 UTC (permalink / raw)
To: pgsql-admin
Hi Achilleas,
>Did you refresh the subscription ? :
>ALTER SUBSCRIPTION name REFRESH PUBLICATION WITH ( COPY_DATA );
Yes, I have performed the above step on the subscriber. But still it is not
replicating.
Help me out of this. This needs to be implemented in production ASAP.
Thanks in Advance.
Regards,
Pavan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Logical Replication in Postgres 10.4
@ 2018-08-13 13:16 pavan95 <pavan.postgresdba@gmail.com>
parent: pavan95 <pavan.postgresdba@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: pavan95 @ 2018-08-13 13:16 UTC (permalink / raw)
To: pgsql-admin
Hi all,
One temporary workaround I found was dropping the subscription and
recreating it again.
Then it started syncing the tables between publisher and subscriber. But
don't know whether it is apt solution to implement here!!
Thanks in Advance!
Regards,
Pavan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Logical Replication in Postgres 10.4
@ 2018-08-20 06:22 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: pavan95 <pavan.postgresdba@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Achilleas Mantzios @ 2018-08-20 06:22 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 13/08/2018 16:16, pavan95 wrote:
> Hi all,
>
> One temporary workaround I found was dropping the subscription and
> recreating it again.
>
> Then it started syncing the tables between publisher and subscriber. But
> don't know whether it is apt solution to implement here!!
>
> Thanks in Advance!
Did you delete the rows from all subscribed tables in the subscriber side in order to start from scratch? (avoid duplicate ERRORs, etc)?
>
>
> Regards,
> Pavan
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
>
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Logical Replication in Postgres 10.4
@ 2018-08-20 06:47 pavan95 <pavan.postgresdba@gmail.com>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 6+ messages in thread
From: pavan95 @ 2018-08-20 06:47 UTC (permalink / raw)
To: pgsql-admin
> Hi all,
>
> One temporary workaround I found was dropping the subscription and
> recreating it again.
>
> Then it started syncing the tables between publisher and subscriber. But
> don't know whether it is apt solution to implement here!!
>
> Thanks in Advance!
>>Did you delete the rows from all subscribed tables in the subscriber side
in order to start from scratch? (avoid duplicate ERRORs, etc)?
Yes
>
>
> Regards,
> Pavan
>
>
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2018-08-20 06:47 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-08-10 05:06 Re: Logical Replication in Postgres 10.4 pavan95 <pavan.postgresdba@gmail.com>
2018-08-10 06:42 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2018-08-13 11:34 ` pavan95 <pavan.postgresdba@gmail.com>
2018-08-13 13:16 ` pavan95 <pavan.postgresdba@gmail.com>
2018-08-20 06:22 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2018-08-20 06:47 ` pavan95 <pavan.postgresdba@gmail.com>
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