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

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

On Thu, Aug 7, 2025 at 12:21=E2=80=AFAM Siraj G <tosiraj.g@gmail.com> wrote=
:

> Yes Ron, database migration service. But it works better if we have to
> migrate all the DBs in one shot
>

Is that really a problem?

But if there's a problem with DMS, then logical replication should do the
trick.


> since it converts the target DB into a read replica during the migration.
>
> Regards
> Siraj
>
> On Thu, Aug 7, 2025 at 9:33=E2=80=AFAM Ron Johnson <ronljohnsonjr@gmail.c=
om>
> wrote:
>
>> On Wed, Aug 6, 2025 at 9:30=E2=80=AFPM Siraj G <tosiraj.g@gmail.com> wro=
te:
>>
>>> 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 thinkin=
g
>>> 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!
>>
>

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

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

<div dir=3D"ltr"><div>On Thu, Aug 7, 2025 at 12:21=E2=80=AFAM Siraj G &lt;<=
a href=3D"mailto:tosiraj.g@gmail.com">tosiraj.g@gmail.com</a>&gt; wrote:</d=
iv><div class=3D"gmail_quote gmail_quote_container"><blockquote class=3D"gm=
ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,=
204,204);padding-left:1ex"><div dir=3D"ltr">Yes Ron, database migration ser=
vice. But it works better if we have to migrate all the DBs in one shot</di=
v></blockquote><div><br></div><div>Is that really a problem?</div><div><br>=
</div><div>But if there&#39;s a problem with DMS, then logical replication =
should do the trick.</div><div>=C2=A0</div><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);=
padding-left:1ex"><div dir=3D"ltr"> since it converts the target DB into a =
read replica during the migration.<div><br></div><div>Regards</div><div>Sir=
aj</div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmai=
l_attr">On Thu, Aug 7, 2025 at 9:33=E2=80=AFAM Ron Johnson &lt;<a href=3D"m=
ailto:ronljohnsonjr@gmail.com" target=3D"_blank">ronljohnsonjr@gmail.com</a=
>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px=
 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><di=
v dir=3D"ltr"><div dir=3D"ltr">On Wed, Aug 6, 2025 at 9:30=E2=80=AFPM Siraj=
 G &lt;<a href=3D"mailto:tosiraj.g@gmail.com" target=3D"_blank">tosiraj.g@g=
mail.com</a>&gt; wrote:</div><div class=3D"gmail_quote"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hello Experts!<br><div><b=
r></div><div>I have this environment with 100+ DBs and would like to migrat=
e 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 CPUs, 12=
8GB memory</div><div>PG version: 12.22 (we have already started the upgrade=
 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 repl=
ication, but wanted to take recommendations if there are better approaches =
available. We cannot afford breaking the read replica due to our read inten=
sive app connects to this node.</div></div></blockquote><div><br></div><div=
></div></div><div>GCP haa a migration service.=C2=A0 Have you investigated =
it?</div><div><br></div><span class=3D"gmail_signature_prefix">-- </span><b=
r><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 alive.=
<br><div><div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>
</blockquote></div>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div=
>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobs=
ter!</div></div></div></div></div></div>

--000000000000b9f053063bbfa3dd--