Manually upgrading the PostgreSQL version of your Amazon RDS database from 9.4 (and below) to 9.6

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: AWS only - This article only applies to Atlassian products on the Server and Data Center platforms attached to an Amazon RDS database.

Bitbucket Data Center deployments created through our AWS Quick Starts are not affected.

Purpose

Starting  , Amazon will start upgrading all Amazon RDS instances using PostgreSQL version 9.4 to 11. You can read about it on their announcement here.

PostgreSQL 11 is not supported on some versions of Bitbucket Server. This means that if your deployment's database is an Amazon RDS instance using PostgreSQL version 9.4, you could end up with an unsupported database after .

Some versions may support PostgreSQL 11

To check if your Jira version supports PostgreSQL 11, go to Supported platforms.  From there, select the correct version of your product from the drop-down.

Solution

To prevent being upgraded to an unsupported database, you'll have to manually upgrade your database instance. We recommend you upgrade to PostgreSQL 9.6, as this version will differ the least from 9.4. This version is also supported across most versions of Jira, Confluence, Bitbucket Server, and Crowd.

Checking your database instance's PostgreSQL version

Remember, your database instance will only be upgraded to PostgreSQL 11 if it's using PostgreSQL 9.4 and below. Otherwise, your database should be safe from the upgrade.

Click here for instructions on how to check your database instance's PostgreSQL version
  1. Sign in to the AWS Management Console, use the region selector in the navigation bar to choose the AWS Region for your deployment, and open the AWS RDS console at https://console.aws.amazon.com/rds.
  2. In the navigation pane, click Databases. From there, select your database instance. You can use the search bar to filter instances by name.
  3. On your database instance's Summary screen, click the Configuration tab. You can view the Engine version from there.


If your Engine version is 9.5.x and up, your instance is safe. 

tip/resting Created with Sketch.

Take a database snapshot

Before you upgrade your database instance's PostgreSQL engine version, we recommend that you take a snapshot of your database. 

Click here for instructions how to take a database snapshot on AWS
  1. Sign in to the AWS Management Console, use the region selector in the navigation bar to choose the AWS Region for your deployment, and open the AWS RDS console at https://console.aws.amazon.com/rds.
  2. In the navigation pane, click Databases. From there, select your database instance. You can use the search bar to filter instances by name.
  3. From the Actions drop-down, select Take snapshot.
  4. The Take DB Snapshot page appears. Enter a name for your snapshot and click Take Snapshot.

For more information, see Creating a DB Snapshot.


To upgrade your database instance's PostgreSQL engine version from 9.4 to 9.6:

  1. Sign in to the AWS Management Console, use the region selector in the navigation bar to choose the AWS Region for your deployment, and open the AWS RDS console at https://console.aws.amazon.com/rds.
  2. In the navigation pane, click Databases. From there, select your database instance. You can use the search bar to filter instances by name.
  3. Click Modify The Modify DB Instance page appears. From there, select PostgreSQL 9.6.16-R1 from the DB engine version drop-down selection.

  4. Choose Continue and check the summary of modifications. By default, the database engine version upgrade will be queued and applied on the next scheduled maintenance window.

    If you prefer to apply the changes immediately, choose Apply immediately. This option can cause an outage in some cases. For more information, see Using the Apply Immediately Setting.

  5. Click Modify DB Instance to save your changes.

For more information, see Manually Upgrading the Engine Version.


Last modified on Apr 17, 2020

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.