Approach for DB migration

From: Siraj G <tosiraj(dot)g(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Approach for DB migration
Date: 2025-08-07 01:29:46
Message-ID: CAC5iy63nxo4+nL_vj1UXp2Py59kZq4yJBXAQEZDwWe=dKrUCaw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Experts!

I have this environment with 100+ DBs and would like to migrate to GCP's
cloud SQL for Postgres.

Primary: 48 CPUs, 48GB memory
Secondary/Read Replica: 80 CPUs, 128GB memory
PG version: 12.22 (we have already started the upgrade process)
OS: Ubuntu

I would like to migrate 2 DBs first and a few more later. I was thinking of
logical replication, but wanted to take recommendations if there are better
approaches available. We cannot afford breaking the read replica due to our
read intensive app connects to this node.

Regards
Siraj

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2025-08-07 04:03:10 Re: Approach for DB migration
Previous Message Adrian Klaver 2025-08-07 01:15:36 Re: PostgreSQL Bug with simple function unexpectedly treating varchar parameter as an array