| 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: | Whole Thread | Raw Message | 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
| 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). |