Migrating Metabase Application DB from MySQL to Postgres

[dwhitemv]

@ztowle you already have a thread open on your issue:

Migrate Metabase DB from MySQL to Postgres via pgloader

Goal: To migrate the current Metabase backend database from MySQL to PostgreSQL. Current MySQL version: Server version: 8.0.37 MySQL Community Server - GPL New PostgreSQL version: postgres (PostgreSQL) 15.12 I have been working through issues with the pgloader utility attempting to migrate our current Metabase backend db from MySQL to PostgreSQL. I have successfully migrated over all of the data but I am unable to properly bring over the foreign key constraints. I have tried many differe…

If you’re still having issues, can you respond to our questions there? We don’t need to dredge someone else’s old thread back up.