Migrate from MariaDB/mySQL to PostgreSQL?

I’m excited about the new PGSQL support in the latest server releases.

Is there any recommended/supported way to migrate a server from a MariaDB backend to a PostgreSQL one? Our instance has an incredibly large number of groups/config changes and it’d be a massive chore to move those individually.

Given differences in backend-specific SQL I think it can’t be as simple as a SQL dump/restore…but is it?

1 Like