Manually upgrading the PostgreSQL version of your Amazon RDS database from 9.6 to 10
Platform Notice: AWS only - This article only applies to Atlassian products on the Server and Data Center platforms attached to an Amazon RDS database.
Note, there are some additional steps for Jira Data Center deployments created through our AWS Quick Starts.
目的
Starting , Amazon will start upgrading all Amazon RDS instances using PostgreSQL 9.6 to PostgreSQL 12. Read more about this in their announcement.
This date was originally but on 17th January, Amazon announced that they were extending the EOL process until . (This is an additional 14 weeks on the original date)
Support for PostgreSQL 12 was added in Jira 8.19. If you are using an earlier version of Jira, and your deployment's database is an Amazon RDS instance using PostgreSQL 9.6, you may end up with an unsupported database after .
ソリューション
Check your database instance's PostgreSQL version
Remember, your database instance will only be automatically upgraded to PostgreSQL 12 if it's using PostgreSQL 9.6 in an Amazon RDS. Otherwise, your database should be safe from the upgrade.
- AWS マネジメント コンソールにサインインし、ナビゲーション バーのリージョン セレクタを使用してご利用のデプロイメントに対応した AWS リージョンを選択して、https://console.aws.amazon.com/rds で AWS RDS コンソールを開きます。
- In the navigation pane, click Databases. From there, select your database instance. You can use the search bar to filter instances by name.
- On your database instance's Summary screen, click the Configuration tab. You can view the Engine version from there.
If your Engine version is higher than 9.6, your instance will not be automatically upgraded. If it is 9.6, you'll need to manually upgrade it.
データベースのスナップショットを作成する
ご利用のデータベース インスタンスの PostgreSQL エンジンのバージョンをアップグレードする前に、データベースのスナップショットを作成することをおすすめします。
- AWS マネジメント コンソールにサインインし、ナビゲーション バーのリージョン セレクタを使用してご利用のデプロイメントに対応した AWS リージョンを選択して、https://console.aws.amazon.com/rds で AWS RDS コンソールを開きます。
- In the navigation pane, click Databases. From there, select your database instance. You can use the search bar to filter instances by name.
- From the Actions drop-down, select Take snapshot.
- The Take DB Snapshot page appears. Enter a name for your snapshot and click Take Snapshot.
詳細については「DB スナップショットの作成」をご確認ください。
To upgrade your database instance's PostgreSQL engine version from 9.6 to 10:
- AWS マネジメント コンソールにサインインし、ナビゲーション バーのリージョン セレクタを使用してご利用のデプロイメントに対応した AWS リージョンを選択して、https://console.aws.amazon.com/rds で AWS RDS コンソールを開きます。
- In the navigation pane, click Databases. From there, select your database instance. You can use the search bar to filter instances by name.
- Click Modify. The Modify DB Instance page appears. From there, select 10.18 from the DB engine version drop-down selection.
- 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.
[Modify DB Instance] をクリックして変更を保存します。
For more information, see Manually Upgrading the Engine Version.
After upgrading, we recommend you run ANALYZE. Analyze collects statistics about the contents of tables in the database, which the query planner can use to help determine the most efficient execution plans for queries.
Additional steps if you use our QuickStart templates
If your current Jira version supports PostgreSQL 10:
- Scale your instance down to zero nodes.
Prepare for and check that a major version upgrade is supported
- Follow the steps above to manually upgrade the Postgres RDS instance from 9.6 to 10.
Important note: don't change theDBEngineVersionparameter in the template, as this will result in a DBGroup error. - Wait for the RDS upgrade to complete.
- Scale your cluster up to 1 node first, check everything is working with no issues, then you can scale your cluster back up to the ideal number.
If your current Jira version does not support PostgreSQL, you will need to upgrade Jira to a version that supports PostgreSQL once the RDS upgrade is complete (before scaling your cluster up to 1 node). For full details of how to upgrade, see Upgrading Jira Data Center on AWS.
Note that the DBEngineVersion parameter in the QuickStart template will continue to be set to version 9.6. If you try to change this parameter you will get a DBGroup error. As long as your application is connected to the new database version, there shouldn't be any problems.