Hello
I see this error
ERROR: could not start WAL streaming: ERROR: replication slot "slot1" is active for PID 28212
2020-12-21 11:01:25.630 GMT [1894324] LOG: background worker "logical replication worker" (PID 1894333) exited with exit code 1
2020-12-21 11:01:25.630 GMT [1894324] LOG: background worker "logical replication worker" (PID 1894333) exited with exit code 1
On Mon, Dec 21, 2020 at 12:09 PM Yambu <hyambu@xxxxxxxxx> wrote:
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 FULLOn 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
