Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-44216

Support Postgres 9.6

XMLWordPrintable

    • 10
    • We collect Confluence feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      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
      1. Shut down Confluence
      2. 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.
      3. 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
      4. Start Confluence again

      Notes

      This is documented here

            [CONFSERVER-44216] Support Postgres 9.6

            Damien Tan made changes -
            Remote Link Original: This issue links to "PC-3549 (Atlassian JIRA Extranet - Special Projects)" [ 301974 ] New: This issue links to "PC-3549 (Hello Jira)" [ 301974 ]
            Sen Geronimo made changes -
            Workflow Original: JAC Suggestion Workflow 4 [ 3579310 ] New: JAC Suggestion Workflow 3 [ 4337561 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow 2 [ 3183884 ] New: JAC Suggestion Workflow 4 [ 3579310 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3027090 ] New: JAC Suggestion Workflow 2 [ 3183884 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing v4 [ 2526921 ] New: JAC Suggestion Workflow [ 3027090 ]
            Mike Ortman made changes -
            Remote Link New: This issue links to "Page (Atlassian Documentation)" [ 381055 ]

            AregVrtanesyan added a comment - - edited

            Confluence documentation states that it is supporting 9.6 from v6.3 and up

            https://confluence.atlassian.com/conf63/supported-platforms-929730053.html

            We are on Enterprise Release 6.6 and all ok.

            AregVrtanesyan added a comment - - edited Confluence documentation states that it is supporting 9.6 from v6.3 and up https://confluence.atlassian.com/conf63/supported-platforms-929730053.html We are on Enterprise Release 6.6 and all ok.

            Mike Monette added a comment -

            @Brett 

            /opt/atlassian/jira/lib

            Had the same trouble finding it.

            Mike Monette added a comment - @Brett  /opt/atlassian/jira/lib Had the same trouble finding it.
            Rachel Robins made changes -
            Remote Link Original: This issue links to "Page (Atlassian Documentation)" [ 349355 ]
            Rachel Robins made changes -
            Remote Link New: This issue links to "Page (Atlassian Documentation)" [ 349355 ]

              ttranminh Tam Tran
              dnorton@atlassian.com Dave Norton
              Votes:
              54 Vote for this issue
              Watchers:
              58 Start watching this issue

                Created:
                Updated:
                Resolved: