Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Preparing for PostgreSQL 9.6 end of life Edited

Hi everyone

Just wanted to remind everyone that the final release of PostgreSQL 9.6 will be in November 2021.  See PostgreSQL Versioning Policy.

Database end of life can be a challenge and upgrading Confluence requires some planning, so we wanted to provide some suggested pathways for upgrading your database. We strongly recommend you keep your database up to date, so that you continue to have access to security fixes. 

Supported databases

Here's a summary of the PostgreSQL versions that are supported for each Confluence Data Center and Server version

Confluence 6.3 to 7.2 7.3 to 7.12 7.12 to 7.13 7.14
PostgreSQL 9.6 tick supported tick supported tick supported cross not supported
PostgreSQL 10 cross not supported tick supported tick supported tick supported
PostgreSQL 11 cross not supported cross not supported tick supported tick supported

For detailed end of support information, see End of Support Announcements for Confluence.

 

Upgrade pathways

There are number of different pathways. Here's a few suggested options.  

If you're running Confluence 7.2 or earlier you can either:

  • Upgrade to Confluence 7.4 LTS, then upgrade your database to PostgreSQL 10, or
  • Upgrade to Confluence 7.12, then upgrade your database to PostgreSQL 10 or 11, or
  • Upgrade to Confluence 7.13 LTS once it is available, then upgrade your database to PostgreSQL 10 or 11. 

If you're running Confluence 7.3 or later you can either:

  • Upgrade your database to PostgreSQL 10, which is supported from Confluence 7.3 onwards,  or
  • Upgrade to Confluence 7.12, then upgrade your database to PostgreSQL 10 or 11, or
  • Upgrade to Confluence 7.13 LTS once it is available, then upgrade your database to PostgreSQL 10 or 11. 

We're working towards adding support for PostgreSQL 12, but this won't be in time for Confluence 7.13 LTS.  

 

Upgrade resources

We strongly recommend using a staging environment to test your upgrade from end to end, before upgrading in production. 

Refer to the following documentation to learn how to upgrade you database:

If you run PostgreSQL 9.6 on an Amazon RDS instance, you should consider planning to upgrade prior to the end of life date, to avoid being automatically upgraded to the latest PostgreSQL version, as happened when PostrgeSQL 9.5 reached end of life.  See Manually upgrading the PostgreSQL version of your Amazon RDS database from 9.5 to 9.6 to see what was involved last time. 

 

I hope you find this info helpful, and it helps you plan your next steps. 

Rachel
Confluence Data Center and Server team

0 comments

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Confluence

👁‍🗨 Confluence Team planning dashboard_Atlympics 🌈

Hi Atlassian's, How is your journey with #Atlympics 2021 so far....excited! Me too, same excitement. Here's my typical team planning and vision dashboard which I used to share to my management and ...

104 views 1 5
Read article

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