Re: How is this possible "publication does not exist"
| От | Dave Cramer |
|---|---|
| Тема | Re: How is this possible "publication does not exist" |
| Дата | |
| Msg-id | CADK3HHJSR+CoY8WW+AgQQMwGTbppaEOEmCo2hiv7YGobf-_LPA@mail.gmail.com обсуждение исходный текст |
| Ответ на | How is this possible "publication does not exist" (Dave Cramer <davecramer@gmail.com>) |
| Ответы |
Re: How is this possible "publication does not exist"
|
| Список | pgsql-hackers |
On Thu, 19 Dec 2019 at 11:59, Dave Cramer <davecramer@gmail.com> wrote:
The publication exists but for some reason the function can't find itSELECT * 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/307D8E8
postgres=# select * from pg_publication;
pubname | pubowner | puballtables | pubinsert | pubupdate | pubdelete | pubtruncate
-----------------+----------+--------------+-----------+-----------+-----------+-------------
dbz_publication | 10 | t | t | t | t | t
(1 row)
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/307D8E8
It seems that if you drop the publication on an existing slot it needs to be recreated. Is this expected behaviour
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
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
Dave Cramer
В списке pgsql-hackers по дате отправления: