Re: Logical replication restarts

From: Mateusz Henicz <mateuszhenicz(at)gmail(dot)com>
To: Paula Berenguel <paulaberenguel007(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Logical replication restarts
Date: 2023-07-06 12:44:53
Message-ID: CAN6i3YMiS0cBLq-PdqDkDGvo+3w6w4qxAtv_iJEsZ3VfL1qLGQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmail(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-07-06 14:01:43 Re: function to_char(unknown) is not unique at character 8
Previous Message Paula Berenguel 2023-07-06 12:34:18 Logical replication restarts