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; } } }

Change from MySQL to PostgreSQL same server

Kyle Johnson_przdl3

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.

Accepted answers

Lasse Langhorn_eakpsc

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

All comments

Lasse Langhorn_eakpsc

Hi Kyle,

I think this should do it.

Regards

Lasse Langhorn

Kyle Johnson_przdl3

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_eakpsc

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

Welcome!

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

Quick Links

Find more posts tagged with

confluence

server

confluence-server

postgres

mysql