Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Evaluation license: How to migrate to external database?

Arkadiusz Nowakowski December 12, 2012

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

0 votes
PauloP
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 12, 2012

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
TAGS
AUG Leaders

Atlassian Community Events