It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Postgresql 10 supported version

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.

1 answer

1 accepted

0 votes
Answer accepted

Hello Jiri,

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.

Regards,

Shannon

Hi Jiri,

Thank you for your response and for sharing that ticket!

From my understanding, is the issue now resolved for you using the workaround from the bug ticket?

Regards,

Shannon

@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.

Hi Jiri,

Thank you for letting me know that you are holding off on upgrading.

If you want to give it a test later with a staging instance, you can try the workaround from the bug. Just let us know if you need our support!

Take care,

Shannon

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

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...

8,411 views 6 6
Join discussion

Community Events

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

Events near you