Is there a known method for doing this ?
Or is it just basically dump the MySQL database and the fiddle with it to make it import the data into Postgres ?
Also need to note that the sequences would need to be set manually probably I imagine.
When I converted over, I did it manually. Most of the MYSQL goes in fine, but you need to remember to set the sequences manually and add the postgres function for setting ownership of tables.
I also went through and changed some column types when I did it.
The one thing I had to do was to use --no-opts (I think) when exporting from MySQL, otherwise it uses short inserts and other MySQL specific options when dumping. I actually did just a data dump (the version of MySQL I dumped from had a Postgres compatible dump option). used step_02 to create the DB tables, and manually set the sequence values.