| From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Approach for DB migration |
| Date: | 2025-08-07 04:03:10 |
| Message-ID: | CANzqJaCWa-RuQFaiEsn4c2H+65peU_vt6O3ZyQvSfhobUz0D2Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Aug 6, 2025 at 9:30 PM Siraj G <tosiraj(dot)g(at)gmail(dot)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 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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Siraj G | 2025-08-07 04:21:18 | Re: Approach for DB migration |
| Previous Message | Siraj G | 2025-08-07 01:29:46 | Approach for DB migration |