Postgres Pro
Downloads
Home   >   mailing lists

Re: Logical replication stops updating - Mailing list pgsql-admin

From Yambu
Subject Re: Logical replication stops updating
Date
Msg-id CALhHtcBF1FC-gFkBqj8wKtLzMp=XRK2k6BmhbgKMhzk0Tozn4Q@mail.gmail.com
Whole thread Raw
In response to Re: Logical replication stops updating  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Logical replication stops updating  (Yambu <hyambu@gmail.com>)
List pgsql-admin
Tree view
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 by date:

Previous
From: abbas alizadeh
Date:
Subject: Pg_upgrade issue
Next
From: Yambu
Date:
Subject: Re: Logical replication stops updating