public inbox for [email protected]help / color / mirror / Atom feed
Approach for DB migration 3+ messages / 2 participants [nested] [flat]
* Approach for DB migration @ 2025-08-07 01:29 Siraj G <[email protected]> 2025-08-07 04:03 ` Re: Approach for DB migration Ron Johnson <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Siraj G @ 2025-08-07 01:29 UTC (permalink / raw) To: [email protected] 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Approach for DB migration 2025-08-07 01:29 Approach for DB migration Siraj G <[email protected]> @ 2025-08-07 04:03 ` Ron Johnson <[email protected]> 2025-08-07 04:21 ` Re: Approach for DB migration Siraj G <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Ron Johnson @ 2025-08-07 04:03 UTC (permalink / raw) To: pgsql-generallists.postgresql.org <[email protected]> On Wed, Aug 6, 2025 at 9:30 PM Siraj G <[email protected]> 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! ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Approach for DB migration 2025-08-07 01:29 Approach for DB migration Siraj G <[email protected]> 2025-08-07 04:03 ` Re: Approach for DB migration Ron Johnson <[email protected]> @ 2025-08-07 04:21 ` Siraj G <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Siraj G @ 2025-08-07 04:21 UTC (permalink / raw) To: Ron Johnson <[email protected]>; +Cc: pgsql-generallists.postgresql.org <[email protected]> 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 AM Ron Johnson <[email protected]> wrote: > On Wed, Aug 6, 2025 at 9:30 PM Siraj G <[email protected]> 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! > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-08-07 04:21 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2025-08-07 01:29 Approach for DB migration Siraj G <[email protected]> 2025-08-07 04:03 ` Ron Johnson <[email protected]> 2025-08-07 04:21 ` Siraj G <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox