RBlhaze
RBlhaze12mo ago

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
Sindre
Sindre12mo ago
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
rubenf
rubenf12mo ago
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
Tiago Serafim
Tiago Serafim12mo ago
Why not bring the original instance to the same version as the target first?
RBlhaze
RBlhaze12mo ago
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!
Damian Szetela
Damian Szetela12mo ago
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