nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Migrate from MS SQL to Postgresql

Umesh Motwani

I am using Confluence 5.8 version with MS SQL database. Now I need to migrate it to Postgresql 5.7 version.

I have installed the software following the guidelines from atlassian and connected it to empty database.

Now I need to do xml backup process as per atlassian. Can someone guide me how to take xmlbackup and migrate the database.

Accepted answers

All comments

Nic Brough -Adaptavist-

It's covered by https://confluence.atlassian.com/doc/migrating-to-another-database-148867.html (that doc has barely changed since version 4)

Umesh Motwani

I tried to follow steps for backup

This allows you to export the contents of the database to a zipped XML file. You can import the XML file into earlier Confluence versions from 5.3 to 5.8.13, and into compatible later versions. When importing, please refer to the compatibility information in the 'restore' section on this page.

Archive to backups folder

Back up attachments

I did hit Backup button but it keeps Loading

I also tried https://thesourceqa.pseg.com/admin/backup.action but this goes to above steps

Nic Brough -Adaptavist-

Yes, you need to let it run the full export. If you think it's failing, you'll need to read the application log to find out what is going wrong.

Umesh Motwani

I have taken the XML Backup for Confluence(Oracle Database). As we are using the “Restore” Option we have placed the backup in the restore directory and the file is visible in the below screenshot..

After clicking on Restore its taking too long to Process. Can you please suggest whether it will take time to process or else is there any other method to follow.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

database

install