Unsupported database type confluence

[sufs]

When we initially set up Confluence, we use PostgreSQL 11 because we install Confluence on a Windows 2016 server. We would like to resolve this Unsupported Database error what is the best path to solving this problem. Is it possible to downgrade to PostgreSQL 10, and if so, how would we do that? 

[repi · Accepted solution]

@sufs 

I would do a fresh install with access to new postgresql db.

According to this description:

Migrating Confluence Between Servers 

[sufs]

Not that big about 150 MB. 

[repi]

Take this opportunity to update confluence to the latest version!

[Joshua Sneed Contegix]

Hi Joliva,

It is possible to downgrade your database. The rough steps are as follows:

1. Export Confluences databases to XML (if necessary).
2. Uninstall PostgreSQL 11.
3. Install PostgreSQL 10.
4. Restore Confluence's database via XML (if necessary).

You can find additional information on Atlassian's Migrating to Another Database documentation and its Related Content sidebar. Cheers!

[sufs]

Hi Joshua,

I have uninstalled PostgreSQL11 and then install PostgreSQL 10 and then edited the Confluence.cfg.xml file to point to the new Postgre database. however, I am getting the following error message when I start the services.

[Joshua Sneed Contegix]

Hi Joliva,

Unfortunately, editing confluence.cfg.xml to point to the new, empty database will not allow Confluence to start. Rename or remove confluence.cfg.xml and restart Confluence. You will need to complete the setup wizard, where you will setup the database. Confluence will connect to and populate the database. After the Wizard, you can Restore your site. Cheers!