Error when migrate to Cloud SQL for PostgreSQL from RDS using Data Migration Service (DMS)

[LongCloudAZ]

I am experiencing an error when using the GCP DMS service. After successfully connecting RDS and Cloud SQL, the test job was successful in DMS. However, after starting DMS, I encountered the following errors:

After I enabled the pg_cron flag, I encountered the following error:

[ms4446]

The errors you're encountering during the migration process using Google Cloud's Data Migration Service (DMS) to migrate to Cloud SQL for PostgreSQL from RDS seem to be related to two main issues:

Error 1: Issues with pg_cron Extension

• Description: Error during replication setup, failing to restore schema due to issues with the pg_cron extension.
• Cause: The pg_cron extension is attempting to install in the public schema instead of the required pg_catalog schema.
• Troubleshooting Steps:
  1. Enable pg_cron Flag: You've already enabled this, which is a good first step.
  2. Review DMS Logs: Check the DMS logs for any additional errors or details related to the pg_cron issue.
  3. Manual Installation: If the problem persists, consider manually installing the pg_cron extension in the pg_catalog schema on your Cloud SQL instance.

Error 2: Database Access Issue

• Description: Error in replication setup due to inability to drop the "postgres" database.
• Cause: The "postgres" database cannot be modified or dropped because it is being accessed by other users.
• Troubleshooting Steps:
  1. Identify and Disconnect Users: Use Cloud SQL's management tools to identify and disconnect any active connections to the "postgres" database.
  2. Review Application Connections: Ensure that no applications or services are using the database during the migration process.
  3. Retry Migration: After ensuring that the database is not being accessed, retry the DMS job.

[LongCloudAZ]

I have opened a support case and solved the problem successfully. Thank you for your advice, it helped me solve the problem faster. Thank you!!

[vildand]

Could you share the solution, I am facing the same issue...

[pavan_p]

what solution provided by support. we are facing same issue