Switching Databases

Hi all, I am really sorry for ruining everyone’s day but you might want to double-check the import is actually successful.

Importing workflows & credentials via the CLI will quietly fail for some of them when using Postgres as reported over here:

This came up in the past too and it was decided not fix it back then:

You might want to follow the original thread for further updates on this. Years ago I have manually imported my workflows into Postgres which worked fine. So I guess the old approach is still worth a try: How to migrate from SQLite to PostgreSQL? - #5 by MutedJam (obviously, there are way more tables these days, also make sure to copy the config file including the encryption key so the credentials can still be used).

1 Like