Re: Logical replication troubles

On 2020-05-20 17:16, Anders Bøgh Bruun wrote:
> [67] LOG:  logical replication apply worker for subscription
> "widgets_sub" has started
> [67] DEBUG:  connecting to publisher using connection string
> "dbname=testdb host=master port=5432 user=repuser password=abc123"
> [67] ERROR:  could not receive data from WAL stream: ERROR:  publication
> "widgets_pub" does not exist
>   CONTEXT:  slot "my_slot", output plugin "pgoutput", in the change
> callback, associated LSN 0/1674958
> [1] DEBUG:  unregistering background worker "logical replication worker
> for subscription 16396"
> [1] LOG:  background worker "logical replication worker" (PID 67) exited
> with exit code 1
>
> I can verify that the publication called widgets_pub does exist, and I
> am not seeing any errors on the sending side.
>
> The SQL-file named "works" just has the creation of the replication slot
> moved down to after I insert some data into the table I want to
> replicate. And that works as expected.

You need to create the publication before the replication slot. The
walsender's view of the world moves along with the WAL it is
decoding/sending. So when the subscription worker connects, it
initially sees a state as of the creation of the replication slot, when
the publication did not exist yet.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services