Unable to create publication

From: Siraj G <tosiraj(dot)g(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Unable to create publication
Date: 2024-06-05 03:51:56
Message-ID: CAC5iy61JdS5KCFqikYVxUA4bnuEMa5EFsOT4bapzHbzs=sXQ5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello -

I am trying to create publication in Source for Publisher-Subscriber
replication, but getting below error:

ERROR: canceling statement due to user request
CONTEXT: while inserting index tuple (0,19) in relation
"pg_publication_pubname_index"

How do we diagnose this?

Regards
Siraj

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kashif Zeeshan 2024-06-05 03:53:54 Re: Unable to create publication
Previous Message Scott Ribe 2024-06-05 03:42:48 Re: postgrsql 9.5: Old WAL files remain in secondary `pg_xlog`