Postgres Pro
Downloads
Home   >   mailing lists

Logical replication restarts - Mailing list pgsql-general

From Paula Berenguel
Subject Logical replication restarts
Date
Msg-id CAOY9d9qFhAYDHAHYFzM1ni+3g_AfZTETSrA4YQ0rBbvYsy7FYQ@mail.gmail.com
Whole thread Raw
Responses Re: Logical replication restarts
List pgsql-general
Tree view
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: Pavel Stehule
Date:
Subject: Re: function to_char(iso-8859-1) is not unique at character 8
Next
From: Mateusz Henicz
Date:
Subject: Re: Logical replication restarts