I am looking to migrate from MySQL to PostgreSQL for my web2py app. While I have a general idea of what to do, I'm not sure if there are any particular things about the PythonAnywhere and web2py environment that I should be taking into account. I have quite a bit of data, so I want to know as much as I can before I can ahead and move forward.
I wanted to use pgloader to make the migration as easy as possible: http://pgloader.io/download.html
However, I'm not quite sure how I would install pgloader on Pythonanywhere.
Has anyone else had experience with this (pgloader, or migrating from MySQL to PostgreSQL on PythonAnywhere), that could shed some light on the process?