Postgres Pro
Downloads
Home   >   mailing lists

Re: How to rename in-use logical replication publication? - Mailing list pgsql-general

From Kristjan Mustkivi
Subject Re: How to rename in-use logical replication publication?
Date
Msg-id CAOQPKatzbn0wb6ERgZUBKt1S734PP7y3R-jWTcjfoFBpcUkeYg@mail.gmail.com
Whole thread Raw
In response to How to rename in-use logical replication publication?  (Kristjan Mustkivi <sonicmonkey@gmail.com>)
List pgsql-general
Tree view 
On Tue, Oct 19, 2021 at 10:31 PM Kristjan Mustkivi
<sonicmonkey@gmail.com> wrote:
> Postgres v11.12. Getting "ERROR:  publication "new_rep_pub" does not
> exist" after renaming an existing publication. And the only way to get
> it working seems to start from scratch. What am I missing?

Ok, the recipe works perfectly in v13.4 which leads me to believe it
is a bug in v11.12.

Best regards,

Kristjan Mustkivi

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Relations between operators from pg_amop and classes of operators from pg_opclass
Next
From: Toomas
Date:
Subject: Can db user change own password?