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"  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список 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 it

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
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

Dave Cramer


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: [PATCH] Remove twice assignment with var pageop (nbtree.c).
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: How is this possible "publication does not exist"