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