Re: How is this possible "publication does not exist"

On 2019-12-19 19:15, Dave Cramer wrote:
> It seems that if you drop the publication on an existing slot it needs
> to be recreated. Is this expected behaviour

A publication is not associated with a slot. Only a subscription is
associated with a slot.

> drop publication dbz_publication ;
> DROP PUBLICATION
> postgres=# create publication dbz_publication for all tables;
> CREATE PUBLICATION
> postgres=# SELECT * FROM pg_logical_slot_get_binary_changes('debezium',
> NULL, NULL,'proto_version','1','publication_names','dbz_publication');
> ERROR:  publication "dbz_publication" does not exist
> CONTEXT:  slot "debezium", output plugin "pgoutput", in the change
> callback, associated LSN 0/4324180

This must be something particular to Debezium.

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