Can i restore postgresql to mariadb?

[ahmadRagheb]

i have a frappe project with postgresql and i want to move it to mariadb to use erpnext features ? is there is a command to do that

[revant_one]

@ahmadRagheb

mariadb to use erpnext

ERPNext not supported.

Can I confidently choose the Frappe + PostgreSQL solution?

If we only consider developing an app using the Frappe framework, how well does Frappe support PostgreSQL? Can I confidently choose the Frappe + PostgreSQL solution?

[Hemil_Sangani]

Firstly, the PostgreSQL database should be backed up to facilitate migration from PostgreSQL to MariaDB in Frappe Project. Then install MariaDB and create your MariaDB database. Convert the PostgreSQL dump into a MariaDB compatible format: either manually, or using pgloader and load that data into MariaDB. Now, modify the Frappe configuration for the new database and test everything post migration.

[ahmadRagheb]

Hi Revant
That’s the reason why I want to move to MariaDB. but I have never done it before, i think this needs a tool or something I thought maybe frappe framework has something to migrate a frappe site with PostgreSQL to MariaDB

[ahmadRagheb]

@Hemil_Sangani

pgloader

i will look at this tool , thank you Hemil