It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

confluence mysql to postgresql migration

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]

2 answers

Hi Dave

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

Rafael Pereira


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.

Hi @Dave Watts,


Was you able to migrate from mysql to postgre?

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...

3,140 views 4 6
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you