Hi
As you may know, over the last few months I undertook the challenge to switch from MySQL to PostgreSQL. If you are interested in my journey, you can read it here:
https://wiki.galaxyproject.org/Community/Log/2015/MySQL2PostgreSQL
It is probably not the best way to do it (and I am sure every PostgreSQL expert would smash her/his head to the desk while reading it), but it worked.
Regards, Hans-Rudolf
galaxy-dev@lists.galaxyproject.org