MIME-Version: 1.0
References: <CAC5iy63nxo4+nL_vj1UXp2Py59kZq4yJBXAQEZDwWe=dKrUCaw@mail.gmail.com>
In-Reply-To: <CAC5iy63nxo4+nL_vj1UXp2Py59kZq4yJBXAQEZDwWe=dKrUCaw@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Thu, 7 Aug 2025 00:03:10 -0400
Message-ID: <CANzqJaCWa-RuQFaiEsn4c2H+65peU_vt6O3ZyQvSfhobUz0D2Q@mail.gmail.com>
Subject: Re: Approach for DB migration
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c90bf1063bbe8981"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCWa-RuQFaiEsn4c2H%2B65peU_vt6O3ZyQvSfhobUz0D2Q%40mail.gmail.com>
Precedence: bulk

--000000000000c90bf1063bbe8981
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wed, Aug 6, 2025 at 9:30=E2=80=AFPM 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 d=
ue
> to our read intensive app connects to this node.
>

GCP haa a migration service.  Have you investigated it?

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

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

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Aug 6, 2025 at 9:30=E2=80=AFPM Si=
raj G &lt;<a href=3D"mailto:tosiraj.g@gmail.com">tosiraj.g@gmail.com</a>&gt=
; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px sol=
id rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hello Experts!<br><d=
iv><br></div><div>I have this environment with 100+ DBs and would like to m=
igrate to GCP&#39;s cloud SQL for Postgres.=C2=A0</div><div><br></div><div>=
<div>Primary: 48 CPUs, 48GB memory</div><div>Secondary/Read Replica: 80 CPU=
s, 128GB memory</div><div>PG version: 12.22 (we have already started the up=
grade process)</div><div>OS: Ubuntu</div></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 recommendations if there are better approa=
ches available. We cannot afford breaking the read replica due to our read =
intensive app connects to this node.</div></div></blockquote><div><br></div=
><div></div></div><div>GCP haa a migration service.=C2=A0 Have you investig=
ated it?</div><div><br></div><span class=3D"gmail_signature_prefix">-- </sp=
an><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to=
 &lt;Redacted&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still a=
live.<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></div></div><=
/div>

--000000000000c90bf1063bbe8981--