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