Evaluation license: How to migrate to external database?

So I've got my Confluence setup on evaluation license with the default database setup that comes with it. Then I decided to (as advised in every Confluence document) to migrate to external PostgreSQL database. I'm sure I did everything as explained on this website: https://confluence.atlassian.com/display/DOC/Migrating+to+Another+Database , but I still can't get it to work.

  1. Make sure that the JDBC drivers for your database are available to the application server. If you don't already have the JDBC driver, please download one from here.
  2. Make sure that your database is using a case-sensitive collation. Please refer to the section on case sensitivity below and see this issue for more details: CONF-7917.
  3. If you are running the Confluence distribution, copy your JDBC database driver (a .jar file), into the <confluence-install>/lib folder.
  4. Start up Confluence. You will see the Confluence Setup Wizard.
  5. Select 'Custom Install'.
  6. Select your database from the drop down list.
  7. Select 'Direct JDBC' and then enter the details of the new database you want to migrate to.
    (info) Read the documentation on the Confluence Setup Wizard for more detailed explanation.
  8. When prompted, restore the contents of the backup you made in Step One into the new Confluence site.

Now, let's see.

1. Since I'm using Postgres, the documentation states that the driver for it is bundled with Confluence.

2. I don't know what the hell that means and why should I care about it if I'm using Postgres?

3. Done.

4. I'm using start-confluence.bat then localhost:8090 and I don't get any wizard but access to the default database.

What am I doing wrong?

1 answer

Hi George

I believe that the best approach would be

1. Install a brand new Confluence instance connecting to an external database. Perhaps you may use the following links as a guideline: https://confluence.atlassian.com/display/CONF43/External+Database

2. Once you have this new instance up and running, using the production system, export all the spaces and pages. This is the link for further details: https://confluence.atlassian.com/display/CONF43/Exporting+Confluence+Pages+and+Spaces+to+XML

3. Import the file created in the previous step to the new instance.

After, you'll have your system running as Confluence + external database. This will also avoid long period of downtime.

For further assistance, perhaps you should raise a new support ticket.

Cheers,

Paulo Renato

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,125 views 17 14
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you