Re: Local replication "slot does not exist" after initial sync

2024-02-25 Thread Justin
On Sun, Feb 25, 2024 at 1:11 PM Mike Lissner wrote: > Sorry, two more little things here. The publisher logs add much, but > here's what we see: > > STATEMENT: START_REPLICATION SLOT > "pg_20031_sync_17418_7324846428853951375" LOGICAL F1D0/346C6508 > (proto_version '2', publication_names '"compas

Re: Local replication "slot does not exist" after initial sync

2024-02-25 Thread Mike Lissner
Sorry, two more little things here. The publisher logs add much, but here's what we see: STATEMENT: START_REPLICATION SLOT "pg_20031_sync_17418_7324846428853951375" LOGICAL F1D0/346C6508 (proto_version '2', publication_names '"compass_publication2"') ERROR: replication slot "pg_20031_sync_17402_73

Local replication "slot does not exist" after initial sync

2024-02-25 Thread Mike Lissner
Hi, I set up logical replication a few days ago, but it's throwing some weird log lines that have me worried. Does anybody have experience with lines like the following on a subscriber: LOG: logical replication table synchronization worker for subscription "compass_subscription", table "search_opi