Could someone recommend a proven way to migrate a database from mysql to Postgresql using a third pa

Maciej Jaroński September 27, 2024

 

As in the topic, I need to migrate mysql -> Postgres DB. I have a very large instance and according to the documentation, in such a case it is discouraged to use XML export/import. I tried to use Pgloader however it failed the test as it interfered too much with the database configuration and confluence did not work properly after the migration. Best regards!

1 answer

1 vote
Aaron Pavez _ServiceRocket_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 27, 2024

Hi @Maciej Jaroński 

It seems the best option is the XML backup.

https://confluence.atlassian.com/doc/migrating-to-another-database-148867.html

Navigate to the backup & restore section in the administration panel. Export your data to an XML file. Proceed by setting up a new instance of Confluence, configuring it with Postgres, and importing your XML file.

Or the hard way(you will need a DBA for this)

https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL

Hope that helps!

Regards

Maciej Jaroński September 30, 2024

 

Hi! Thanks for answer!

Unfortunate - As is mentioned in the link you provided -"Large data sets will require third party database migration tools." and this is exactly my case.

 

That's why i need to find the other solution.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events