From: | "sunyucong(at)gmail(dot)com" <sunyucong(at)gmail(dot)com> |
---|---|
To: | Justin <zzzzz(dot)graf(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Need help debugging slow logical replication |
Date: | 2023-02-08 02:10:54 |
Message-ID: | CAJygYd3Qfo4Pu4DWo1y-Qu6NaTjAwQrhQybR_wNCw-BjR5Jagw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Justin, thanks for the response!
> REPLICA IDENTITY DEFAULT will only use primary keys, if the publisher includes those tables, the subscriber when replaying the WAL will stop throwing an error not knowing how to replay the UPDATE/DELETE.
But I don't see any errors being thrown out in the postgresql logs?
Should I be seeing it complain there? Is postgresql falling back to
replica identity full here?
However I checked that table, it doesn't seem to be making progress at
all: so I suspect you are right that it is the problem.
> Logical Replication is most likely broken at this point.
>
> I suggest stopping logical replication and correcting tables that don't have qualifying indexes for logical replication by creating the necessary indexes and avoid using replica identity full. Then restart logical replication from the beginning.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Brad White | 2023-02-08 04:20:58 | Re: Quoting issue from ODBC |
Previous Message | Justin | 2023-02-08 01:32:35 | Re: Need help debugging slow logical replication |