Re: Logical replication stops updating

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx> 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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux