confluence mysql to postgresql migration

[Dave Watts]

I have had great luck with pgloader transfering data excerpt for one table, plugindata.  Does anyone have any hints on the proper casting for the fields?  The problem field seems to be named data and defined as a LONGBLOB. The migration is from MySQL 5.1 to Postgresql 9.3 using pgloader version "3.2.0"

Examples of the pgloader errors: 

The value 33354273 is not of type (UNSIGNED-BYTE 24).
DEBUG copy-batch plugindata 5 rows [oversized]

[Igor Boyko]

Hi @Dave Watts,

Was you able to migrate from mysql to postgre?

[Rafael Pereira]

Hi Dave

You might consider to use the XML backup to migrate, as described here: Migrating to Another Database

Cheers,
Rafael Pereira

[Malik Mangier]

Unfortunately sometimes it's just not possible. Not only the XML may take hours (10+) before it fails:

root cause java.lang.ClassNotFoundException: javax.xml.bind.DatatypeConverter not found by com.atlassian.activeobjects.activeobjects-plugin [17]

And in addition there's no guaranty that even if this specific problem is solved, there won't be more problems after that. Kind of tree hiding the forest situation...

In those situations, a direct DB migration would be a better strategy.