Change from MySQL to PostgreSQL same server

[Kyle Johnson]

I originally installed Confluence using MySQL and I would like to change it to PostgreSQL while keeping it on the same server. I took a snapshot before I did anything, and took a backup and copied that off anywhere else. 

I've installed postgresql and configured it to how the documentation says to configure it. I have not migrated any data into the postgresql database yet.

What would my next steps be? I don't want to move to a new VM, I would like to continue using this same VM just with a different database type. We are a very small installation out total confluence back up is 30MB. Thank you for any help.

[Lasse Langhorn · Accepted solution]

Hi Kyle,

I would do the following:
1. While Confluence is still running on your MySQL database I would do a XML backup. Described here: https://confluence.atlassian.com/doc/manually-backing-up-the-site-152405.html
2. Stop your Confluence server.
3. Configure your Confluence server to use the PostgreSQL database. Described here: https://confluence.atlassian.com/doc/database-setup-for-postgresql-173244522.html
4. Start your Confluence server.
5. When Confluence has been started you should be able to walk through the installation process again.
6. When logged in Confluence running on PostgreSQL then restore the XML backup that was created in step 1. Restoring is described her: https://confluence.atlassian.com/doc/restoring-a-site-152034.html

I think this should do it.

Regards

Lasse Langhorn

[Kyle Johnson]

Thank you Lasse for the reply!

I have a question about step 5, I assume I shouldn't be uninstalling confluence first, but I can't figure out how to get it to prompt me for the installation questions again without fully uninstalling and reinstalling the package. 

My apologies for my incompetence.

Thank you

[Lasse Langhorn]

Hi Kyle,

Sorry for the late feedback.

What you need to do is in step 3 is to locate the confluence.cfg.xml file which is located in the <confluence_home> directory. Here are the database properties. You should change these values to reflect the Postgresql connection.

Then start Confluence, try access the URL: http:<your-ip>:8090 and see if Confluence can detect your Postgresql database and will walk you through the installation setup.

Regards

Lasse