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?
Regards
Siraj