Details
-
Suggestion
-
Resolution: Fixed
-
10
-
Description
NOTE: This suggestion is for Confluence Server. Using Confluence Cloud? See the corresponding suggestion.
Confluence does not support Postgres 9.6, and will throw error messages like the following:
org.postgresql.util.PSQLException: ERROR: column am.amcanorder does not exist
Upgrading the Postgres Driver to the newest version seems to resolve the problem, however Atlassian Support will not be able to provide support for this configuration until this improvement is implemented in a future version.
Upgrade the Postgres Driver
- Shut down Confluence
- Copy confluence-install/confluence/WEB-INF/lib/postgresql-9.x-xxxx.jdbc4.jar to a safe location as a backup, and then delete the file.
- From the Postgres Website, download the most recent driver and copy it to the same location
- Despite its name, the JDBC 9.4 driver is compatible with Postgres 9.6
- Start Confluence again
Notes
This is documented here
Attachments
Issue Links
- is blocked by
-
CONFSERVER-45557 Update jdbc.postgresql.driver.version to 9.4.1212
-
- Closed
-
- relates to
-
- Closed
- is incorporated by
-
PC-3549 Loading...
- mentioned in
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-