confluence mysql to postgresql migration

Question

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]

Malik Mangier · Answer

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.

Igor Boyko · Answer

Hi @Dave Watts,

Was you able to migrate from mysql to postgre?

Rafael Pereira · Answer

Hi Dave

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

Cheers,
Rafael Pereira