We are in the process of moving our self-hosted Retool instance from one server to another. We have a Retool instance stood up on the new server with the same version. We followed the steps outlined in this support document, but are experiencing issues.
- Export data from Retool's Docker container
We executed the command to export all data from the existing server into the retool_db_dump.sql file
docker-compose exec postgres
pg_dump hammerhead_production --no-acl --no-owner --clean
-U retool_internal_user -f retool_db_dump.sql
- Copied the SQL file to the new server and placed the file in the root directory
- Migrate the data into the new server database
docker-compose exec postgres
psql hammerhead_production -U retool_internal_user -f retool_db_dump.sql
- Restart the server
sudo docker-compose up -d
While this method did copy over all the apps, users, settings, query library, it did NOT copy Resources and the Permission Groups for users. On the new server, if I try to edit a query, it says "Resource xxxxxx-xxx--xxx does not exist". For some reason, this information and user permission groups will not get copied over.
Does anyone have any ideas on how to handle this?