Hi Siraj
It all depends on your requirements, you can use as many publication as you want as per your requirements.
Regards
Kashif Zeeshan
On Mon, Jun 24, 2024 at 7:50 AM Siraj G <tosiraj.g@xxxxxxxxx> wrote:
Hello Team!We are trying to migrate a on-premise PgSQL (v10) to GCP Cloud SQL's PgSQL (v10) via PubSub replication. I am trying to get familiar with best practices in this context. We built 2 publications - one for all tables with Primary Keys and other for non-Primary Keys. There are few archive tables with non-primary key are having issues in the replication. How do we troubleshoot this? Is it a best practice to bifurcate publications this way?RegardsSiraj
