Postgres Pro
Downloads
Home   >   mailing lists

Re: Logical replication restarts - Mailing list pgsql-general

From Mateusz Henicz
Subject Re: Logical replication restarts
Date
Msg-id CAN6i3YMiS0cBLq-PdqDkDGvo+3w6w4qxAtv_iJEsZ3VfL1qLGQ@mail.gmail.com
Whole thread Raw
In response to Logical replication restarts  (Paula Berenguel <paulaberenguel007@gmail.com>)
List pgsql-general
Tree view
Hi,
There should be another line in the log for why the logical replication worker has stopped in the first place. Something like Primary Key or Unique Constraint violation, timeout on WAL sender or receiver process, etc.
Unless you can provide that information I doubt someone will be able to help here.

Check logs on your both publisher and subscriber, with this information you should be able to find the solution.

Cheers,
Mateusz

czw., 6 lip 2023 o 14:34 Paula Berenguel <paulaberenguel007@gmail.com> napisał(a):
Hi
I am using logical replication to move an on premises database PG11 to a cloud based PG11 and experiencing constant restart of the replication. 

The replication does it again. The validation_entry started again:

2023-07-06 01:49:46.968 UTC-64a61dba.1ad8----LOG: 00000: logical replication table synchronization worker for subscription "subXXXX", table "ZZZYYY" has started

2023-07-04 21:10:36.478 UTC-64a48b93.961----LOG: 00000: logical replication table synchronization worker for subscription "subXXXX", table " ZZZYYY" has started


Can someone help me to find a fix for this? 


Thanks

Paula

pgsql-general by date:

Previous
From: Paula Berenguel
Date:
Subject: Logical replication restarts
Next
From: Ron
Date:
Subject: Re: function to_char(iso-8859-1) is not unique at character 8