Confluence migrate from Oracle DB to Postgres

Is there any way to migrate Confluence from an Oracle DB to a Postgres DB without having to do a complete Confluence Install?

When migrating JIRA from Oracle to Postgres, I was able to drop the dbconfig.xml, restart JIRA and the Config Wizard started;allowing me to point to the new DB and restore all my data from the XML backup.

 

Dropping the confluence.config.xml file in Confluence and restarting did not bring up the Config Wizard.

The documentation states you need to reinstall Confluence, changing your install and home directory paths. You then need to reinstall all the plugins and copy over all your attachments. I was hoping to avoid all of this.

3 answers

1 accepted

In the case of migrating Confluence from Oracle to PostGres, a full install of Confluence is required.

Hi Jeanne,

You can use a tool like ora2pg: http://ora2pg.darold.net/ to migrate a database from Oracle to Postgres. Once you have successfully migrated the database, you should be able to change your confluence.config.xml file with the new Database connection.

e.g.

...
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://DatabaseServer:5432/DatabaseName"
...

 

Obviously, take full backup's first,

Jared.

0 vote

Hi Jeanne, 

 

Since deleting confluence.cfg.xml is not working, can you try to setup a new confluence.cfg.xml? Try to create one with the following content:

<?xml version="1.0" encoding="UTF-8"?>
<confluence-configuration>
  <setupStep>setupstart</setupStep>
  <setupType>initial</setupType>
  <buildNumber>0</buildNumber>
  <properties/>
</confluence-configuration>

(remember to stop Confluence first and then make a backup of your old confluence.cfg.xml. Then, start Confluence again smile

 

Regards, 
Renato Rudnicki 

Renato, I have tried starting Confluence using this file, still the setup wizard does not start. I have also tried creating the full confluence.cfg.xml for postgres, but got the following error on startup 2015-12-30 11:09:53,983 INFO [localhost-startStop-1] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 5.7.5 [build 5791 based on commit hash 812a9b95d028838dafa0cb0b1f30f9320f96e54f] 2015-12-30 11:09:56,045 ERROR [localhost-startStop-1] [atlassian.config.bootstrap.DefaultAtlassianBootstrapManager] init Home is not configured properly: com.atlassian.config.ConfigurationException: Failed to create config element: com.atlassian.config.xml.Dom4jXmlMapConfigElement at com.atlassian.config.AbstractConfigurationPersister.getConfigElement(AbstractConfigurationPersister.java:82) at com.atlassian.config.AbstractConfigurationPersister.getConfigElement(AbstractConfigurationPersister.java:26) at com.atlassian.config.ApplicationConfig.load(ApplicationConfig.java:266) at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.init(DefaultAtlassianBootstrapManager.java:68) at com.atlassian.config.util.BootstrapUtils.init(BootstrapUtils.java:36) at com.atlassian.confluence.setup.ConfluenceConfigurationListener.initialiseBootstrapContext(ConfluenceConfigurationListener.java:129) at com.atlassian.confluence.setup.ConfluenceConfigurationListener.contextInitialized(ConfluenceConfigurationListener.java:64) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5016) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5528) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1575) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1565) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.NullPointerException at com.atlassian.config.xml.Dom4jXmlMapConfigElement.loadConfig(Dom4jXmlMapConfigElement.java:43) at com.atlassian.config.AbstractConfigElement.load(AbstractConfigElement.java:23) at com.atlassian.config.AbstractConfigurationPersister.getConfigElement(AbstractConfigurationPersister.java:78)

Hi Jeanne, Looks like your confluence_home flag wasn't properly setup as you can see: 2015-12-30 11:09:56,045 ERROR [localhost-startStop-1] [atlassian.config.bootstrap.DefaultAtlassianBootstrapManager] init Home is not configured properly: Can you verify this on <confluence_installation_folder>/confluence/WEB-INF/classes/confluence-init.properties Cheers, Renato

Hi Jeanne, In addition to Renato's suggestion, also ensure that the user that is starting Confluence has full read/write permission to the Confluence Home and other important directories, including permission to create and delete subfolders. Even if the permissions look correct, sometimes there can be a few errant files that have the wrong permissions, so it's a good idea to reset the permissions and force them to be reapplied to the Home directory and all subfolders and files. Thanks, Jared.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

910 views 23 12
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