Re: How is this possible "publication does not exist" - Mailing list pgsql-bugs

From Amit Kapila
Subject Re: How is this possible "publication does not exist"
Date
Msg-id CAA4eK1KhL+TeVrKUVpScrq3PP5WCLWU6AyaVdnm__N9yBDAWgA@mail.gmail.com
Whole thread Raw
In response to How is this possible "publication does not exist"  (operations i <ioperations.c@gmail.com>)
List pgsql-bugs
On Tue, May 24, 2022 at 7:51 AM operations i <ioperations.c@gmail.com> wrote:
I have found this topic (https://www.postgresql.org/message-id/89b22955-bf9f-f7f2-9620-fbe2e4766a18%402ndquadrant.com)
cause I have the same problem in my environment, and I'd like to continue the story .
it seems the problem will definitely occur when start the script.
find an empty directory and start the script .

The problem is due to the reason that the slot used for sending changes to the subscription is created before publication. So, when we decode the changes (in your case 'insert') and check the respective publication, it won't exist by that time. The same problem is being discussed in a slightly different context in the email [1]. As a workaround, if you create a slot after creating a publication, you should not see this error.


--
With Regards,
Amit Kapila.

pgsql-bugs by date:

Previous
From: John Naylor
Date:
Subject: Re: BUG #17491: PgAgent keeps failing
Next
From: PG Bug reporting form
Date:
Subject: BUG #17492: error MSB4126: The specified solution configuration "Release|arm64" is invalid