Migrating mysql 9.5 to Postgres

Troubleshooting
1

I’m having issues migrating my mysql db to postgres due to the mysql db being on version 9.5, I can’t use pgloader as I get an UNSUPPORTED-AUTHENTICATION error and I can’t activate the mysql_native_password plugin as it’s not supported past mysql 8

My mysql docker container is running server 9.5

I rolled back the mattermost docker container to 10.9 as I missed that we were supposed to migrate before version 11

Just unsure of how to continue as most documentation I’m seeing only works for older mysql versions so not sure of my best way forward and ChatGPT keeps taking me in loops.

2

I think I got it figured out. I ended up having to spin up a temporary mysql 8.5 container, dump the db, import it into the older one, then I was able to run pgloader and transfer it over to postgres