MIME-Version: 1.0
From: Siraj G <tosiraj.g@gmail.com>
Date: Thu, 7 Aug 2025 06:59:46 +0530
Message-ID: <CAC5iy63nxo4+nL_vj1UXp2Py59kZq4yJBXAQEZDwWe=dKrUCaw@mail.gmail.com>
Subject: Approach for DB migration
To: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000446949063bbc657c"
Archived-At: <https://www.postgresql.org/message-id/CAC5iy63nxo4%2BnL_vj1UXp2Py59kZq4yJBXAQEZDwWe%3DdKrUCaw%40mail.gmail.com>
Precedence: bulk

--000000000000446949063bbc657c
Content-Type: text/plain; charset="UTF-8"

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

--000000000000446949063bbc657c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hello Experts!<br><div><br></div><div>I have this environm=
ent with 100+ DBs and would like to migrate to GCP&#39;s cloud SQL for Post=
gres.=C2=A0</div><div><br></div><div><div>Primary: 48 CPUs, 48GB memory</di=
v><div>Secondary/Read Replica: 80 CPUs, 128GB memory</div><div>PG version: =
12.22 (we have already started the upgrade process)</div><div>OS: Ubuntu</d=
iv></div><div><br></div><div>I would like to migrate 2 DBs first and a few =
more later. I was thinking of logical replication, but wanted to take recom=
mendations if there are better approaches available. We cannot afford break=
ing the read replica due to our read intensive app connects to this node.</=
div><div><br></div><div>Regards</div><div>Siraj</div></div>

--000000000000446949063bbc657c--