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

Atlassian Database Check Utility - No suitable driver found for jdbc:postgres

Andrew Samokish

Hello,

I`m trying to install Confluence 5.1.5 with custom PostgreSQL database to restore the existing database and then upgrade to a newer one.

I`m not able to connect to PostgreSQL server at the setup step, can you help me, please?

I did manage to setup testdatabase.jsp and got this result (https://confluence.atlassian.com/conf63/troubleshooting-external-database-connections-929729726.html):

Found driver (org.postgresql.Driver) on classpath Connection failed to open on the JDBC URL: java.sql.SQLException: No suitable driver found for jdbc:postgres://localhost:5492/test

I have PostgreSQL 9.2 installed on my PC (found, that Confluence 5.1.5 contains a driver for PostgreSQL 9.2)

Accepted answers

All comments

Shannon S

Hello Andrew,

Thank you for reaching out! Happy to help.

I believe your error might be due to a misconfiguration in the database URL, due to what I read from the article PostgreSQL: "java.sql.SQLException: No suitable driver found".

Have a look at our article on Database Setup for Postgresql for details:

The database URL is entered in this format:
jdbc:postgresql://<server>:<port>/<database>
For example:
jdbc:postgresql://localhost:5432/confluence

If you need to connect to an SSL database, add the ssl=true parameter in the database URL. For example:
jdbc:postgresql://localhost:5432/confluence?ssl=true

Your URL is using postgres rather than postgresql. I would recommend updating that and let me know if you're able to connect.

In addition, due to the two recent security advisories, (Confluence Security Advisory - 2019-03-20 and Confluence Security Advisory - 2019-04-17), you will want to upgrade to the latest Confluence versions.

My recommended changes would be:

Make sure your Postgres server is on version 9.4, 9.5, or 9.6. Create a new database for Confluence.
Create a clean install of the latest Confluence version.
Connect your new Confluence instance to the new database.
Restore your Confluence site XML backup at this step. Note we do not recommend restoring from a database dump, the XML backup is the way to go.

Let me know if you have any questions about this.

Regards,

Shannon

Andrew Samokish

Hello Shannon,

As I understand, to perform the XML backup I need to have a workable Counfluence (we have only database backup).

And also I need to restore the old confluence before and perform the upgrade then.

I did manage to install the Confluence 5.1.5, the problem was related to JRE - the version #7 (not supported for now) was required to make it work.

Now we can perform XML backup and migrate to a newer Confluence.

I think the best possibility for us is to use Cloud Confluence instead of the local server.

Sincerely yours, Andrew

Shannon S

Andrew,

My apologies, as your message indicated you were migrating from 5.1.5, I was not aware that your previous installation was also not in working order. In addition, when migrating the initial step is to create the XML backup so I was not aware that you hadn't had a chance to do that yet.

If you wish to migrate from Server to Cloud, then you will want to upgrade first to 5.10 or higher so you can use the Server to Cloud migration tool.

Please review Plan your Confluence Server to Cloud Migration for full details on how to migrate to Cloud. Let us know if you have any question or get stuck along the way.

Regards,
Shannon

Andrew Samokish

Thank you Shannon, those links and information are useful to me

Regards,

Andrew

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