Guidance on Safely Migrating Directus from MySQL to PostgreSQL

Hey everyone :waving_hand:

I’m planning to migrate a self-hosted Directus project from MySQL to PostgreSQL, and I’d really appreciate some guidance from folks who’ve done this before or from the core team.

Where I’m a bit unsure (and don’t want to mess things up) is around:

  • The safest way to migrate everything, or should i even migrate everything? system tables i meant!
  • How to handle collections, fields, and files
  • Whether using tools like pgloader (excluding system tables) is a sane approach

If there’s an officially recommended workflow or any gotchas I should be aware of, I’d love to learn before going ahead.

Thanks a lot — and thanks for building such a solid platform :folded_hands: