Logical replication restarts

From: Paula Berenguel <paulaberenguel007(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Logical replication restarts
Date: 2023-07-06 12:34:18
Message-ID: CAOY9d9qFhAYDHAHYFzM1ni+3g_AfZTETSrA4YQ0rBbvYsy7FYQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mateusz Henicz 2023-07-06 12:44:53 Re: Logical replication restarts
Previous Message Pavel Stehule 2023-07-06 11:54:19 Re: function to_char(unknown) is not unique at character 8