How do I migrate my erpnext from MariaDB to postgresql?

[Danilo1727]

I’m trying to migrate my ERPNext from MariaDB to PostgreSQL, but I haven’t been successful so far, any recommendations?

[ejaaz]

MariaDB to Postgres migration

I was able to use pgloader to migrate between local MariaDB and Postgres instances. I ran into a problem with a default value in ‘tabBank Statement Settings’, which had no data in my case. I ran drop table tabBank Statement Settings; to remove it and then everything went fine. LOAD DATABASE FROM mysql://root:password@localhost/dbname INTO pgsql://postgres:password@localhost/dbname WITH include drop, create tables, create indexes, reset sequences -- EXCLUDING TABLE NAMES MATCHING "tabBank Stat…

How to Migrate MariaDB to Postgres: A Step-By-Step Guide