Available PostgreSQL database versions
Amazon RDS supports DB instances running several editions of PostgreSQL. You can specify any currently available PostgreSQL version when creating a new DB instance. You can specify the major version (such as PostgreSQL 14), and any available minor version for the specified major version. If no version is specified, Amazon RDS defaults to an available version, typically the most recent version. If a major version is specified but a minor version is not, Amazon RDS defaults to a recent release of the major version you have specified.
To see a list of available versions, as well as defaults for newly created DB
instances, use the describe-db-engine-versions AWS CLI command. For example, to
display the default PostgreSQL engine version, use the following command:
aws rds describe-db-engine-versions --default-only --engine postgres
For details about the PostgreSQL versions that are supported on Amazon RDS, see the Amazon RDS for PostgreSQL Release Notes.
If you aren't ready to manually upgrade to a new major engine version before the RDS
end of standard support date, Amazon RDS will automatically enroll your databases in
Amazon RDS Extended Support after the RDS end of standard support date. Then, you can continue to run
RDS for PostgreSQL version 11 and higher. For more information, see Amazon RDS Extended Support with Amazon RDS and Amazon RDS pricing
Deprecation of PostgreSQL version 10
On April 17, 2023, Amazon RDS plans to deprecate PostgreSQL 10 using the following schedule. We recommend that you take action and upgrade your PostgreSQL databases running on major version 10 to a later version, such as PostgreSQL version 14. To upgrade your RDS for PostgreSQL major version 10 DB instance from a PostgreSQL version older than 10.19, we recommend that you first upgrade to version 10.19 and then upgrade to version 14. For more information, see Upgrades of the RDS for PostgreSQL DB engine.
| Action or recommendation | Dates |
|---|---|
|
The PostgreSQL community plans to deprecate PostgreSQL 10 and won't provide any security patches after this date. |
November 10, 2022 |
|
Start upgrading RDS for PostgreSQL 10 DB instances to a later major version, such as PostgreSQL 14. Although you can continue to restore PostgreSQL 10 snapshots and create read replicas with version 10, be aware of the other critical dates in this deprecation schedule and their impact. |
Until February 14, 2023 |
|
After this date, you can't create new Amazon RDS instances with PostgreSQL major version 10 from either the AWS Management Console or the AWS CLI. |
February 14, 2023 |
|
After this date, Amazon RDS automatically upgrades PostgreSQL 10 instances to version 14. If you restore a PostgreSQL 10 database snapshot, Amazon RDS automatically upgrades the restored database to PostgreSQL 14. |
April 17, 2023 |
For more information about RDS for PostgreSQL version 10 deprecation, see [Announcement]: RDS for PostgreSQL 10 deprecation
Deprecation of PostgreSQL version 9.6
On March 31, 2022, Amazon RDS plans to deprecate PostgreSQL 9.6 using the following schedule. This extends the previously announced date of January 18, 2022 to April 26, 2022. You should upgrade all your PostgreSQL 9.6 DB instances to PostgreSQL 12 or higher as soon as possible. We recommend that you first upgrade to minor version 9.6.20 or higher and then upgrade directly to PostgreSQL 12 rather than upgrading to an intermediate major version. For more information, see Upgrades of the RDS for PostgreSQL DB engine.
| Action or recommendation | Dates |
|---|---|
|
The PostgreSQL community discontinued support for PostgreSQL 9.6, and will no longer provide bug fixes or security patches for this version. |
November 11, 2021 |
|
Start upgrading RDS for PostgreSQL 9.6 DB instances to PostgreSQL 12 or higher as soon as possible. Although you can continue to restore PostgreSQL 9.6 snapshots and create read replicas with version 9.6, be aware of the other critical dates in this deprecation schedule and their impact. |
Until March 31, 2022 |
|
After this date, you can't create new Amazon RDS instances with PostgreSQL major version 9.6 from either the AWS Management Console or the AWS CLI. |
March 31, 2022 |
|
After this date, Amazon RDS automatically upgrades PostgreSQL 9.6 instances to version 12. If you restore a PostgreSQL 9.6 database snapshot, Amazon RDS automatically upgrades the restored database to PostgreSQL 12. |
April 26, 2022 |
Deprecated versions for Amazon RDS for PostgreSQL
RDS for PostgreSQL 9.5 is deprecated as of March, 2021. For more information about
RDS for PostgreSQL 9.5 deprecation, see Upgrading
from Amazon RDS for PostgreSQL version 9.5
To learn more about deprecation policy for RDS for PostgreSQL, see Amazon RDS FAQs
