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!
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.