Migrate data from production retool database to other environemnts

Hello,

Is there a way to create a database dump and restore it into different environments? I successfully connected to Retool database via PgAdmin, but I'm not able to fully restore a backup due to permissions. I just want to replicate the data available in 1 environment into another.

Thanks!

Hello @nickfind!

If you are looking to migrate your data from a Retool Database to your self-hosted instance of Retool DB, you can read about that process on our docs here!

-Are you looking to move data from one Postgres DB to another Postgres DB?

-Or from Retool DB to a Postgres DB?

-Across which environments are you looking to move the data?

-At what level is there permissions that are preventing access to backed up data?

As long as you have access to the data there should be a potential solution to moving/migrating the data else where :sweat_smile: