Switch to postgresql from mysql as application database

Get Help
1

Hey there,

I use mysql as application database currently. I want to change it to postgresql. In this post, @ erfantkerfan said it is problematic to directly switch to postgresql from mysql due to some issues, and his recommended approach is to dump mysql to h2 and then load to postgresql. Which approach (direct vs thru-h2) is recommended per offical?

2

The only one I know is pgloader - About

3

Only time I did it was via H2. I was wary of any differences in data types to do a migration.
Just make sure your truncate the log and query/cache tables or it will run until Christmas (2025 :smiley: )