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

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

Yes Ron, database migration service. But it works better if we have to
migrate all the DBs in one shot 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.com=
> wrote:

> On Wed, Aug 6, 2025 at 9:30=E2=80=AFPM Siraj G <tosiraj.g@gmail.com> wrot=
e:
>
>> 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!
>

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

<div dir=3D"ltr">Yes Ron, database migration service. But it works better i=
f we have to migrate all the DBs in one shot since it converts the target D=
B into a read replica during the migration.<div><br></div><div>Regards</div=
><div>Siraj</div></div><br><div class=3D"gmail_quote gmail_quote_container"=
><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Aug 7, 2025 at 9:33=E2=80=AF=
AM Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com">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"><div 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"_blan=
k">tosiraj.g@gmail.com</a>&gt; wrote:</div><div class=3D"gmail_quote"><bloc=
kquote 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">Hello Experts=
!<br><div><br></div><div>I have this environment with 100+ DBs and would li=
ke to migrate to GCP&#39;s cloud SQL for Postgres.=C2=A0</div><div><br></di=
v><div><div>Primary: 48 CPUs, 48GB memory</div><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</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=
 approaches available. We cannot afford breaking the read replica due to ou=
r read intensive app connects to this node.</div></div></blockquote><div><b=
r></div><div></div></div><div>GCP haa a migration service.=C2=A0 Have you i=
nvestigated it?</div><div><br></div><span class=3D"gmail_signature_prefix">=
-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">D=
eath 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>

--000000000000b3415a063bbeca64--