Request a Demo
Home   >   mailing lists

Re: Approach for DB migration - Mailing list pgsql-general

From Ron Johnson
Subject Re: Approach for DB migration
Date
Msg-id CANzqJaCWa-RuQFaiEsn4c2H+65peU_vt6O3ZyQvSfhobUz0D2Q@mail.gmail.com
Whole thread Raw
In response to Approach for DB migration  (Siraj G <tosiraj.g@gmail.com>)
Responses Re: Approach for DB migration
List pgsql-general
Tree view
On Wed, Aug 6, 2025 at 9:30 PM Siraj G <tosiraj.g@gmail.com> wrote:
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.

GCP haa a migration service.  Have you investigated it?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

Previous
From: Siraj G
Date:
Subject: Approach for DB migration
Next
From: Siraj G
Date:
Subject: Re: Approach for DB migration