[SOLVED] Migrating database from MySQL to PostgreSQL

I am currently running Metabase using MySQL as database, and I want do migrate it to a PostgreSQL. Have anyone done this? How can I do it?

Thanks all in advance!

Hi @PabloBrenner
I’ve used pgLoader a few times and it’s worked like a treat. But I had to use the latest build instead of the release on several occasions, because there were some issues that was not yet fixed in the release. Not sure if that’s still the case, but just wanted to note it.
https://pgloader.io/
EDIT: DO has a tutorial you might want to check too:
https://www.digitalocean.com/community/tutorials/how-to-migrate-mysql-database-to-postgres-using-pgloader

1 Like

Flamber, thanks a lot for the reply!

After migrating all tables and data, for metabase for “understand” the new database will it work if I just change the MB_DB_ variables before running?

@PabloBrenner
Yes, it should Just Work™, but you should of course make backups before starting the migration and then when you start Metabase using Postgres for the first time, then you’ll want to check the logs at startup, but also during at least the first hour.
By the way, I’m guessing you’re using the latest 0.32.10 release. It’s important that you don’t try to migrate and upgrade in the same process, since it might fail or corrupt the metadata.

1 Like

Thanks a lot!