public inbox for [email protected]
help / color / mirror / Atom feedFrom: Siraj G <[email protected]>
To: [email protected]
Subject: Approach for DB migration
Date: Thu, 7 Aug 2025 06:59:46 +0530
Message-ID: <CAC5iy63nxo4+nL_vj1UXp2Py59kZq4yJBXAQEZDwWe=dKrUCaw@mail.gmail.com> (raw)
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
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Approach for DB migration
In-Reply-To: <CAC5iy63nxo4+nL_vj1UXp2Py59kZq4yJBXAQEZDwWe=dKrUCaw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox