Re: Need help debugging slow logical replication

Поиск
Список
Период
Сортировка
От sunyucong@gmail.com
Тема Re: Need help debugging slow logical replication
Дата
Msg-id CAJygYd3Qfo4Pu4DWo1y-Qu6NaTjAwQrhQybR_wNCw-BjR5Jagw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Need help debugging slow logical replication  (Justin <zzzzz.graf@gmail.com>)
Ответы Re: Need help debugging slow logical replication  ("sunyucong@gmail.com" <sunyucong@gmail.com>)
Список 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
replayingthe 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
replicationby creating the necessary indexes and avoid using replica identity full.  Then restart logical replication
fromthe beginning.
 
>
>



В списке pgsql-general по дате отправления:

Предыдущее
От: Justin
Дата:
Сообщение: Re: Need help debugging slow logical replication
Следующее
От: Brad White
Дата:
Сообщение: Re: Quoting issue from ODBC