I want to know how to migrate from SQLite to PostgreSQL

[ze_bin_lin]

I want to know how to migrate from SQLite to PostgreSQL. I initially used Docker and defaulted to SQLite, but now I want to migrate to PostgreSQL. When I try to transfer all the table data, I encounter various errors. The workflow cannot be debugged or enabled, and all tokens need to be re-entered, but even after re-entering them, it still doesn’t work.

[aspiess]

Check the character encoding of your tokens in both databases SQLite and PostgreSQL. Migrating UTF8 encoded tokens to any 8-Bit-encoding (e.g. ISO-LATIN-1) might break them.

[ghostcoder]

@ze_bin_lin

I want to know how to migrate from SQLite to PostgreSQL. I initially used Docker and defaulted to SQLite, but now I want to migrate to PostgreSQL. When I try to transfer all the table data, I encounter various errors. The workflow cannot be debugged or enabled, and all tokens need to be re-entered, but even after re-entering them, it still doesn’t work.

I wrote a doc breaking down your issue and helping you with the fixes: Troubleshooting: n8n SQLite to PostgreSQL Migration Issues - Google Docs