Hi Siraj,
Please go through PostgreSQL documentation first to develop better understanding.
Later you may go through some videos on Youtube or google. There are tons of step by step examples available.
Regards,
Muhammad Ikram
Bitnine Global
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
Muhammad Ikram