Re: Approach for DB migration

2025-08-06 Thread Ron Johnson
On Thu, Aug 7, 2025 at 12:21 AM Siraj G 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

Re: Approach for DB migration

2025-08-06 Thread Siraj G
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 wrote: > On Wed, Aug 6, 2025 at 9:30 PM Siraj G wrote: > >>

Re: Approach for DB migration

2025-08-06 Thread Ron Johnson
On Wed, Aug 6, 2025 at 9:30 PM Siraj G 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

Approach for DB migration

2025-08-06 Thread Siraj G
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 fir