Re: Logical replication troubleshooting

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Siraj G <tosiraj(dot)g(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Logical replication troubleshooting
Date: 2024-06-24 08:10:53
Message-ID: 7bfff0e14ede5e219a861671ede101649f11d8d2.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, 2024-06-24 at 08:20 +0530, Siraj G wrote:
> We are trying to migrate a on-premise PgSQL (v10) to GCP Cloud SQL's PgSQL (v10) via PubSub replication.
> There are few archive tables with non-primary key are having issues in the replication.

That's not surprising. You should create primary keys, if necessary only for the replication.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-06-24 08:13:37 Re: Segmentation Fault Issue in PostgreSQL 13.4
Previous Message Muhammad Ikram 2024-06-24 04:02:04 Re: Logical replication troubleshooting