I followed these steps and this proved to be wrong,
There is no way you can migrate from mysql to postgres directly.
Here is the issue I created on github: After changing metabase database from mysql to pgsql migration checksums check fails · Issue #37101 · metabase/metabase · GitHub
you have to dump mysql to h2 and then load it into postgres