Migrating from Sqlite to Postgres Assistance

Hi @Keep_Innovations, sorry for the confusion and sorry for my late reply. I saw your DM only now.

I can see that you’re referring to my post at How to migrate from SQLite to PostgreSQL? - #5 by MutedJam. If you scroll down a bit, you will see that I suggested using the CLI in a response a couple of years after I originally posted the manual instructions.

I’ve now edited the original post to also include this information, but for visibility I’ll copy it here too:

This post was written a long time ago when n8n was using a very different database structure and did not have the functionality to export/import data stored in the database.

So please do not follow these steps anymore. Instead, refer to the CLI instructions at CLI commands | n8n Docs for information on how to export data from one n8n instance and import it to another.

1 Like