Self-hosted instance workspace bulk migration
Hi all. I'm trying to migrate a workspace from a self-hosted windmill server to another running a newer version (v1.179.1 -> v 1.214). I was trying to find an easy method to do so, and i managed to export the workspace as a .zip file from the "Delete Workspace" menu, but i'm struggling to find an import process. The two instances run two different Postgres versions (12.x -> 16.x) so i'm not quite confident with the idea of just dump the db and restore it on the new instance. Could anyone suggest a recommended method for this type of task? Any advice or insights would be greatly appreciated.
Many thanks in advance for your kind support.
5 Replies
Try using the #ask-ai for help. Its really good. You prop want to reach for the windmill cli for this. Check docs or ask the ai
I don't think you risk much doing the pgdump, and then load it into the new db
otherwise I would get familiar with the cli, sync pull, create the new instance with the new workspace then sync push
Why not bring the original instance to the same version as the target first?
I will give it a try, ty. Eventually i will get back here with some feedback.
I hope i didn't got something wrong troubleshooting the deployment process, but the new version of windmill I was trying to install seemed being incompatible with potsgres 12 so the deployment process failed repeatedly. Hence the new installation.
This actually worked pretty well, i will give it a few days to test my scheduled flows an apps, but the environment went up smoothly and no data appear to be missing.Thanks a lot for now! If anything else comes up, I'll post in this thread. Hope everyone has a great weekend!
Maybe this will be of some help ...
Recently I did a Postgresql upgrade on Debian using apt-get upgrade command. After that was done there were 2 versions of postgresql listed under postgresql service. To upgrade it from version 13 to 15 I had to do following steps:
sudo su - postgres
pg_lsclusters
pg_dropcluster --stop 15 main
pg_upgradecluster 13 main
exit
systemctl stop postgresql@13-main
sudo su - postgres
pg_dropcluster --stop 13 main
exit
apt purge postgresql-13 postgresql-client-13