Re: Logical replication stops updating

Поиск
Список
Период
Сортировка
От Yambu
Тема Re: Logical replication stops updating
Дата
Msg-id CALhHtcBF1FC-gFkBqj8wKtLzMp=XRK2k6BmhbgKMhzk0Tozn4Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Logical replication stops updating  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: Logical replication stops updating
Список pgsql-admin
Дерево обсуждения
Thanks Laurenz,

I got the error below, and i added the primary key on slave table1, but how do i fix the other error  " published relation does not have REPLICA IDENTITY FULL"

logical replication target relation "public.table1" has neither REPLICA IDENTITY index nor PRIMARY KEY and published relation does not have REPLICA IDENTITY FULL

On Mon, Dec 21, 2020 at 11:51 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Mon, 2020-12-21 at 11:48 +0200, Yambu wrote:
> My logical replication stopped updating, how do i make it start again?

Read the standby log file and fix the problem you see there.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

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

Предыдущее
От: abbas alizadeh
Дата:
Сообщение: Pg_upgrade issue
Следующее
От: Yambu
Дата:
Сообщение: Re: Logical replication stops updating