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.
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