Unable to migrate from CloudSQL Postgres to AlloyDB - Google ...
Share this topic
LinkedIn
Twitter
Copy URL
Issue with Migration Process
Hi there, I'm facing challenges while attempting to migrate data from a CloudSQL Postgres 14 database to AlloyDB. The migration process is failing, and I am encountering the following error message:
"The extensions installed on the source database are either not supported or are using unsupported versions.
database postgres has unsupported extensions installed: google_vacuum_mgmt; database other_db has unsupported extensions installed: google_vacuum_mgmt"
Upon investigation, I confirmed that the mentioned extension is indeed installed on the database. However, due to the lack of superuser privileges, I am unable to delete it. Unfortunately, none of the available flags seem to offer a solution for its removal.
Investigation and Attempts
While examining the logs, I came across the following relevant information: yet I was unable to locate a flag named cloudsql.enable_google_vacuum_mgmt. Additionally, when reviewing the instance description, I observed the following: indicating a potential relation to Gemini in Databases functionality.
Even after attempting to call the update endpoint, it became evident that the googleVacuumMgmtEnabled field could not be modified. I experimented with proceeding with the migration despite the warning, but encountered the same error. Furthermore, my efforts to disable Gemini in Databases indicated a waiting period of 30 days.
Seeking Solutions
My inquiries led me to question whether I might be overlooking any crucial steps. Is it feasible to utilize the migrator for CloudSQL Postgres servers when Gemini in Databases is active? Are there any measures in place to deactivate this functionality for a specific server, or is there an alternative method to expedite the migration process earlier than the stipulated 30 days?
Any insights or guidance on this matter would be greatly appreciated. Thank you!
