How is this possible "publication does not exist"

From: Dave Cramer <davecramer(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: How is this possible "publication does not exist"
Date: 2019-12-19 16:59:05
Message-ID: CADK3HH+9uPg=anB-thAMojVhsZk3tYWMwux4YmHB2+ByJXcE3w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Dave Cramer

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2019-12-19 17:47:22 Re: WIP/PoC for parallel backup
Previous Message Ranier Vilela 2019-12-19 16:41:44 RE: [PATCH] Remove twice assignment with var pageop (nbtree.c).