Postgres Pro
Downloads
Home   >   mailing lists

Re: Logical replication troubleshooting - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Logical replication troubleshooting
Date
Msg-id 7bfff0e14ede5e219a861671ede101649f11d8d2.camel@cybertec.at
Whole thread Raw
In response to Logical replication troubleshooting  (Siraj G <tosiraj.g@gmail.com>)
Responses Re: Logical replication troubleshooting
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Muhammad Ikram
Date:
Subject: Re: Logical replication troubleshooting
Next
From: Laurenz Albe
Date:
Subject: Re: Segmentation Fault Issue in PostgreSQL 13.4