A very much imperfect migration script for Roundcube.
Used successfully for a small deployment running roundcubemail:1.6.12.
To use, set database connections strings in roundcube.load, path in roundcube-schema-run.sql (\ir didn't work for me for some reason), and run pgloader roundcube.load.
roundcube-schema.sql was derived by running roundcube on a fresh database and dumping the contents. In hindsight, I should have taken SQL from roundcube repository. (note: comments need to be stripped)
pgloader still shows some type casting warnings… but seems to migrated correctly. It's possible that things would break if more of roundcube features were used on that instance.