Pre-requisites on moving from Retool DB to Google Cloud SQL using Database Migration Service

Self Hosted Retool
1

Hello Retool team,

I would like to migrate my data from Retool DB to Google Cloud SQL for security compliance. I intend to use Google Cloud Data Migration service since it supports continuous synchronization rather than one-time migration.

However, to do it, one of the pre-requisites needs to be done in the source database. This is the documentation for reference: Configure your source  |  Database Migration Service  |  Google Cloud.

I have tried the first step which is running CREATE EXTENSION IF NOT EXISTS pglogical but got error "extension pglogical is not available".

What can be done in this case?

3

Hey @Christoforus_Widodo! Welcome back to the community and thanks for reaching out.

Assuming your instance is hosted on the Retool cloud, this sadly won't be possible as a result of not having root access to the RetoolDB database servers. Is there a reason that you are trying to go this direction instead of just creating a database dump?

1 Like