Would it be possible to explicitly specify in the docs what specific versions of Postgresql 10 are supported?
According to https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html and https://confluence.atlassian.com/doc/supported-platforms-207488198.html both JIRA and Confluence Support Postgresql 10 but omit to list the exact version of Postgresql 10 supported, unlike the versions of Postgresql 9 which are explicitly listed.
The Postgresql 10 family has subversions 10.1 - 10.11.
I have just tried 10.11 and had to revert back since there were tons of errors on permissions.
All versions of PostgreSQL 10 are supported in the latest release of Confluence.
If you're encountering issues, check the Confluence 7.3 Upgrade Notes:
PostgreSQL 10 support
We've added support for PostgreSQL 10. If you plan to upgrade, you should upgrade Confluence first, then upgrade your database.
See pg-upgrade in the PostgreSQL 10 documentation for information on how to upgrade your database. Make sure you back up your database, Confluence installation directory and Confluence home directory before you begin. We strongly recommend you test your changes in a staging environment first.
After upgrading, we recommend you run ANALYZE. Analyze collects statistics about contents of tables in the database, which the query planner can use to help determine the most efficient execution plans for queries.
There's also a known issue where Confluence won't start with PostgreSQL 10 in Amazon RDS. See CONFSERVER-59243 - Upgrade to Postgres 10 on AWS RDS Confluence can't find tables LONG TERM BACKLOG for more information and a workaround.
If you continue to encounter issues, then I'll need to know more about how your Confluence site was set up, if it's a new installation, an upgrade, and the steps you took to migrate your database exactly.
@Shannon Spaniol : I have experienced the problem reported in CONFSERVER-59243, then have reverted back to the PostgreSQL 9 and am waiting for Confluence's and Jira's support of PostgreSQL 11 and then I will not upgrade, but rather reimport everything so that all permissions are set right.
Thank you for all your help.
Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events