Amazon RDS for PostgreSQL updates
Amazon RDS supports DB instances running several versions 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 10) 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 isn't, Amazon RDS defaults to a recent release of the major version that you specified.
To see a list of available versions, and also 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
To learn more about versioning policy for RDS for PostgreSQL, see
Amazon RDS FAQs
Topics
Deprecation of PostgreSQL 10
On April 17, 2023, Amazon RDS plans to deprecate PostgreSQL 10. For more information, see Deprecation of PostgreSQL version 10 in the Amazon RDS User Guide. We strongly recommend that you take action as soon as possible and upgrade your PostgreSQL databases running on major version 10 to a later major version, such as version 14. For information about how to do so, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.
Deprecation of PostgreSQL 9.6
On March 31, 2022, Amazon RDS deprecated PostgreSQL 9.6. This extended the previously announced date of January 18, 2022 to April 26, 2022. For more information, see Deprecation of PostgreSQL version 9.6 in the Amazon RDS User Guide. We strongly recommend that you upgrade all your PostgreSQL 9.6 DB instances to PostgreSQL 12 or higher as soon as possible. For information about how to do so, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.
PostgreSQL 15 versions
Minor versions
PostgreSQL version 15.2 on Amazon RDS
PostgreSQL version 15.2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the
PostgreSQL 15 release
New features and enhancements
The archive library
rds_archive
is now used for archiving wal files instead ofarchive_command
.The
lz4
andzstd
wal compression methods are now supported.
New extensions
The
pg_walinspect
version 1.0 was added.
Extension updates
btree_gist
was updated from 1.6 to 1.7.hll
was updated from 2.16 to 2.17.mysql_fdw
was updated from 2.7.0 to 2.9.0.pageinspect
was updated from 1.10 to 1.11.pg_hint_plan
was updated from 1.4.0 to 1.5.0.pg_repack
was updated from 1.4.7 to 1.4.8.pg_stat_statements
was updated from 1.9 to 1.10.pgaudit
was updated from 1.6.2 to 1.7.0.pglogical
was updated from 2.4.1 to to 2.4.2.pgrouting
was updated from 3.2.2 to 3.4.1.pllcoffee
was updated from 2.3.15 to 3.1.4.plls
was updated from 2.3.15 to 3.1.4.plprofiler
was updated from 4.1.0 to 4.2.1.plv8
was updated from 2.3.15 to 3.1.4.postgis
was updated from 3.1.7 to 3.3.2.tds_fdw
was updated from 2.0.2 to 2.0.3.
For version information on all extensions, see Extensions supported for RDS for PostgreSQL 15.
PostgreSQL 14 versions
Minor versions
PostgreSQL version 14.7 on Amazon RDS
PostgreSQL version 14.7 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the
PostgreSQL 14.7 release
For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.
PostgreSQL version 14.6 on Amazon RDS
PostgreSQL version 14.6 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the
PostgreSQL 14.6 release
New features and enhancements
PostgreSQL version 14.6 added support for the
tcn
("triggered change notification") extension which generates notification events on table changes via a trigger function calledtriggered_change_notification
. The tcn extension is useful for applications using drivers which support asynchronous notification. This makes it possible to notify all clients if the contents of a table have been changed, enabling them to take appropriate action in near-real time, such as updating a table cache or information display.However, such functionality should only be used with care as it makes all data changes on the table available to all clients (including unprivileged users) through the notification events when they listen on the tcn channel. It is the user’s responsibility to avoid using tcn trigger on a table with sensitive data to avoid information leakage.
This version includes the following changes:
The seg extension version 1.4 is added.
The tcn extension version 1.0 is added.
The orafce extension is updated to 3.24.
The pgaudit extension is updated to 1.6.2.
The pgtap extension is updated to 1.2.0.
The rdkit extension is updated to 4.2.0.
The PostGIS dependency GDAL is updated to 3.4.3.
The wal2json extension is updated to 2.5.
The aws_s3 extension is updated to 1.1.
For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.
PostgreSQL version 14.5 on Amazon RDS
PostgreSQL version 14.5 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the
PostgreSQL 14.5 release
This version includes the following changes:
The PostGIS extension is updated to 3.1.7
The pg_partman extension is updated to 4.6.2
The pgRouting extension is updated to 3.2.2
For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.
PostgreSQL version 14.4 on Amazon RDS
PostgreSQL version 14.4 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the
PostgreSQL 14.4 release
New features and enhancements
While this release includes other fixes, a noteworthy fix included in this release is for
CREATE INDEX CONCURRENTLY
andREINDEX CONCURRENTLY
that can potentially cause silent data corruption of indexes. Amazon RDS has made the fix for the index corruption available since the release of Amazon RDS for PostgreSQL 14.3. This release does not include any RDS specific changes or extension version updates.
For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.
PostgreSQL version 14.3 on Amazon RDS
PostgreSQL version 14.3 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the
PostgreSQL 14.3 release
New features and enhancements
This release includes Amazon RDS collations designed to help with data migration from EBCDIC-based systems. For more information, see RDS for PostgreSQL collations for EBCDIC and other mainframe migrations.
This release includes a fix that was made available in the PostgreSQL out-of-cycle release June 16, 2022
that resolves the CREATE INDEX CONCURRENTLY
andREINDEX CONCURRENTLY
issue. The issue affects all community PostgreSQL 14 versions prior to 14.4. For information about how to detect and remediate the issue, see PostgreSQL 14 out-of-cycle release June 16, 2022.
This version also includes the following changes:
The pglogical
extension is updated to 2.4.1. The pg_hint_plan
extension is updated to 1.4. The postgresql-hll
extension is updated to 2.16.
For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.
PostgreSQL version 14.2 on Amazon RDS
PostgreSQL version 14.2 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in
PostgreSQL 14.2
This version also includes the following changes:
The mysql_fdw
extension version 2.7.0 is added. For more information, see Working with MySQL databases by using the mysql_fdw extension. The tds_fdw
extension version 2.0.2 is added. For more information, see Working with SQL Server databases by using the tds_fdw extension in the Amazon RDS User Guide. The pgaudit
extension is updated to 1.6.1. For information about using this extension with RDS for PostgreSQL, see Logging at the session and object level with the pgaudit extension. The lo
(large objects) module is updated to version 1.1.
For version information on all extensions, see Extensions supported for RDS for PostgreSQL 14.
PostgreSQL version 14.1 on Amazon RDS
PostgreSQL version 14.1 is now available on Amazon RDS. This release contains several improvements that were announced in
PostgreSQL 14.1
This version also includes the following changes:
-
The old_snapshot
extension 1.0 is added. If you set old_snapshot_threshold
to a value, this extension lets you map transaction ID to a timestamp. The amcheck
extension is updated to version 1.3. The btree_gist
extension is updated to version 1.6. The cube
extension is updated to version 1.5. The hstore
extension is updated to version 1.8. The intarray
extension is updated to version 1.5. The pageinspect
extension is updated to version 1.9. The pg_cron extension is upgraded to version 1.4
The pg_partman extension is upgrade to version 4.6.0.
The pg_repack
extension is updated to version 1.4.7. The pg_stat_statements
extension is updated to version 1.9. The pg_trgm
extension is updated to version 1.6. The pgaudit
extension is updated to version 1.6. The pgrouting
extension is updated to version 3.2.0. The postgres_fdw
extension is updated to version 1.1.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 14.
PostgreSQL 13 versions
Minor versions
- PostgreSQL version 13.10 on Amazon RDS
- PostgreSQL version 13.9 on Amazon RDS
- PostgreSQL version 13.8 on Amazon RDS
- PostgreSQL version 13.7 on Amazon RDS
- PostgreSQL version 13.6 on Amazon RDS
- PostgreSQL version 13.5 on Amazon RDS
- PostgreSQL version 13.4 on Amazon RDS
- PostgreSQL version 13.3 on Amazon RDS
- PostgreSQL version 13.2 on Amazon RDS (deprecated)
- PostgreSQL version 13.1 on Amazon RDS (deprecated)
PostgreSQL version 13.10 on Amazon RDS
PostgreSQL version 13.10 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the
PostgreSQL 13.10 release
For version information on all extensions, see Extensions supported for RDS for PostgreSQL 13.
PostgreSQL version 13.9 on Amazon RDS
PostgreSQL version 13.9 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the
PostgreSQL 13.9 release
New features and enhancements
PostgreSQL version 13.9 added support for the
tcn
("triggered change notification") extension which generates notification events on table changes via a trigger function calledtriggered_change_notification
. The tcn extension is useful for applications using drivers which support asynchronous notification. This makes it possible to notify all clients if the contents of a table have been changed, enabling them to take appropriate action in near-real time, such as updating a table cache or information display.However, such functionality should only be used with care as it makes all data changes on the table available to all clients (including unprivileged users) through the notification events when they listen on the tcn channel. It is the user’s responsibility to avoid using tcn trigger on a table with sensitive data to avoid information leakage.
This version includes the following changes:
The seg extension version 1.3 is added.
The tcn extension version 1.0 is added.
The orafce extension is updated to 3.24.
The pgaudit extension is updated to 1.5.2.
The pgtap extension is updated to 1.2.0.
The PostGIS dependency GDAL is updated to 3.4.3.
The PostGIS dependency PROJ is updated to 8.0.1.
The wal2json extension is updated to 2.5.
The aws_s3 extension is updated to 1.1.
For version information on all extensions, see Extensions supported for RDS for PostgreSQL 13.
PostgreSQL version 13.8 on Amazon RDS
PostgreSQL version 13.8 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in
PostgreSQL 13.8
This version includes the following changes:
For information on all extensions, see Extensions supported for RDS for PostgreSQL 13.
PostgreSQL version 13.7 on Amazon RDS
PostgreSQL version 13.7 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in
PostgreSQL 13.7
This version also includes the following changes:
The pglogical
extension is updated to 2.4.1
For information on all extensions, see Extensions supported for RDS for PostgreSQL 13.
PostgreSQL version 13.6 on Amazon RDS
PostgreSQL version 13.6 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in
PostgreSQL 13.6
This version also includes the following changes:
The mysql_fdw
extension version 2.7.0 is added. For more information, see Working with MySQL databases by using the mysql_fdw extension in the Amazon RDS User Guide. The tds_fdw
extension version 2.0.2 is added. For more information, see Working with SQL Server databases by using the tds_fdw extension in the Amazon RDS User Guide. The pgaudit
extension is updated to 1.5.1. For information about using this extension with RDS for PostgreSQL, see Logging at the session and object level with the pgaudit extension in the Amazon RDS User Guide. The lo
(large objects) module is updated to version 1.1.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 13.
PostgreSQL version 13.5 on Amazon RDS
PostgreSQL version 13.5 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in
PostgreSQL 13.5
This version also includes the following change:
-
The pg_cron
extension is updated to 1.4.1
For information on all extensions, see Extensions supported for RDS for PostgreSQL 13.
PostgreSQL version 13.4 on Amazon RDS
PostgreSQL version 13.4 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in
PostgreSQL 13.4
This version also includes the following changes:
The
flow_control
extension version 1.0 is added in this release.-
The spi module
extensions refint, autoinc, inset_username, and moddatetime version 1.0 are added. -
The pgrouting
extension is updated to version 3.1.3. -
The
pglogical
extension is updated to version 2.4.0. -
The PostGIS extension is updated to version 3.1.4, along with the following related extensions:
For information on all extensions, see Extensions supported for RDS for PostgreSQL 13.
PostgreSQL version 13.3 on Amazon RDS
PostgreSQL version 13.3 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in
PostgreSQL 13.3
This version also includes the following changes:
-
The oracle_fdw
extension version 2.3.0 is added. For more information, see Working with Oracle databases by using the oracle_fdw extension in the Amazon RDS User Guide. -
The orafce
extension is updated to version 3.15. -
The pg_cron extension is updated to version 1.3.1.
-
The pg_partman extension is updated to version 4.5.1.
-
The PostGIS extension is updated to version 3.0.3, along with the following related extensions:
For information on all extensions, see Extensions supported for RDS for PostgreSQL 13.
PostgreSQL version 13.2 on Amazon RDS (deprecated)
PostgreSQL version 13.2 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in PostgreSQL 13.2
This version also added the following new extensions:
-
The
aws_lambda
extension version 1.0. For more information, see Invoking an AWS Lambda function from an RDS for PostgreSQL DB instance in the Amazon RDS User Guide. -
The pg_bigm
extension version 1.2.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 13.
PostgreSQL version 13.1 on Amazon RDS (deprecated)
PostgreSQL version 13.1 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in
PostgreSQL 13.0
This version added:
-
The
bool_plperl
extension version 1.0. -
The
rds_tools
extension version 1.0. For more information, see Checking for users with non-SCRAM passwords.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 13.
PostgreSQL 12 versions
Minor versions
- PostgreSQL version 12.14 on Amazon RDS
- PostgreSQL version 12.13 on Amazon RDS
- PostgreSQL version 12.12 on Amazon RDS
- PostgreSQL version 12.11 on Amazon RDS
- PostgreSQL version 12.10 on Amazon RDS
- PostgreSQL version 12.9 on Amazon RDS
- PostgreSQL version 12.8 on Amazon RDS
- PostgreSQL version 12.7 on Amazon RDS
- PostgreSQL version 12.6 on Amazon RDS (deprecated)
- PostgreSQL version 12.5 on Amazon RDS (deprecated)
- PostgreSQL version 12.4 on Amazon RDS (deprecated)
- PostgreSQL version 12.3 on Amazon RDS (deprecated)
- PostgreSQL version 12.2 on Amazon RDS (deprecated)
PostgreSQL version 12.14 on Amazon RDS
PostgreSQL version 12.14 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the
PostgreSQL 12.14 release
For version information on all extensions, see Extensions supported for RDS for PostgreSQL 12.
PostgreSQL version 12.13 on Amazon RDS
PostgreSQL version 12.13 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the
PostgreSQL 12.13 release
New features and enhancements
PostgreSQL version 12.13 added support for the
tcn
("triggered change notification") extension which generates notification events on table changes via a trigger function calledtriggered_change_notification
. The tcn extension is useful for applications using drivers which support asynchronous notification. This makes it possible to notify all clients if the contents of a table have been changed, enabling them to take appropriate action in near-real time, such as updating a table cache or information display.However, such functionality should only be used with care as it makes all data changes on the table available to all clients (including unprivileged users) through the notification events when they listen on the tcn channel. It is the user’s responsibility to avoid using tcn trigger on a table with sensitive data to avoid information leakage.
This version includes the following changes:
The seg extension version 1.3 is added.
The tcn extension version 1.0 is added.
The orafce extension is updated to 3.24.
The pgaudit extension is updated to 1.4.3.
The pgtap extension is updated to 1.2.0.
The PostGIS dependency GDAL is updated to 3.4.3.
The PostGIS dependency PROJ is updated to 7.0.1.
The wal2json extension is updated to 2.5.
The aws_s3 extension is updated to 1.1.
For version information on all extensions, see Extensions supported for RDS for PostgreSQL 12.
PostgreSQL version 12.12 on Amazon RDS
PostgreSQL version 12.12 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in
PostgreSQL 12.12
This version includes the following changes:
For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.
PostgreSQL version 12.11 on Amazon RDS
PostgreSQL version 12.11 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in
PostgreSQL 12.11
This version also includes the following changes:
The pglogical
extension is updated to 2.4.1.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.
PostgreSQL version 12.10 on Amazon RDS
PostgreSQL version 12.10 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in
12.10
This version also includes the following changes:
The pgaudit
extension is updated to 1.4.2. For information about using this extension with RDS for PostgreSQL, see Logging at the session and object level with the pgaudit extension. The lo
(large objects) module is updated to version 1.1.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.
PostgreSQL version 12.9 on Amazon RDS
PostgreSQL version 12.9 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in
12.9
This version also includes the following changes:
-
The pg_cron
extension is updated to 1.4.1 -
The pg_hint_plan
extension is updated to 1.3.7.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.
PostgreSQL version 12.8 on Amazon RDS
PostgreSQL version 12.8 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in
12.8
This version also includes the following changes:
For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.
PostgreSQL version 12.7 on Amazon RDS
PostgreSQL version 12.7 is now available on Amazon RDS. PostgreSQL version 12.7 contains several improvements that were
announced for PostgreSQL release 12.7
This version also includes the following changes:
-
The oracle_fdw
extension version 2.3.0 is added. For more information, see Working with Oracle databases by using the oracle_fdw extension in the Amazon RDS User Guide. -
The orafce
extension is updated to version 3.15. -
The pg_cron extension is updated to version 1.3.1.
-
The pg_partman extension is updated to version 4.5.1.
-
The PostGIS extension is updated to version 3.0.3, along with the following related extensions:
For information on all extensions, see PostgreSQL version 12 extensions supported on Amazon RDS in the Amazon RDS User Guide.
PostgreSQL version 12.6 on Amazon RDS (deprecated)
PostgreSQL version 12.6 is now available on Amazon RDS. PostgreSQL version 12.6
contains several improvements that were announced for PostgreSQL release
12.6
This version also includes the following changes:
-
The
aws_lambda
extension version 1.0 is added. For more information, see Invoking an AWS Lambda function from an RDS for PostgreSQL DB instance in the Amazon RDS User Guide. -
The pg_bigm
extension version 1.2 is added. -
The PostGIS extension is updated to version 3.0.2.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.
PostgreSQL version 12.5 on Amazon RDS (deprecated)
PostgreSQL version 12.5 is now available on Amazon RDS. PostgreSQL version 12.5
contains several improvements that were announced for PostgreSQL release
12.5
This version also includes the following changes:
-
Added the
pg_partman
extension version 4.4.0. For more information, see Managing PostgreSQL partitions with the pg_partman extension in the Amazon RDS User Guide. -
Added the
pg_cron
extension version 1.3.0. For more information, see Scheduling maintenance with the PostgreSQL pg_cron extension in the Amazon RDS User Guide.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.
PostgreSQL version 12.4 on Amazon RDS (deprecated)
PostgreSQL version 12.4 is now available on Amazon RDS. PostgreSQL version 12.4
contains several improvements that were announced for PostgreSQL release
12.4
This version also includes the following changes:
-
Added the
pg_proctab
extension version 0.0.9 -
Added the
rdkit
extension version 3.8 -
Upgraded the
aws_s3
extension to version 1.1. -
Upgraded the
pglogical
extension to version 2.3.2 -
Upgraded the
wal2json
extension to version 2.3
For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.
PostgreSQL version 12.3 on Amazon RDS (deprecated)
PostgreSQL version 12.3 is now available on Amazon RDS. PostgreSQL version 12.3
contains several improvements that were announced for PostgreSQL release
12.3
This version also includes the following changes:
-
Upgraded the
pg_hint_plan
extension to version 1.3.5. -
Upgraded the
pglogical
extension to version 2.3.1.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.
PostgreSQL version 12.2 on Amazon RDS (deprecated)
PostgreSQL version 12.2 is now available on Amazon RDS. PostgreSQL version 12.2
contains several improvements that were announced for PostgreSQL releases
12.0
For information on all extensions, see Extensions supported for RDS for PostgreSQL 12.
PostgreSQL 11 versions
Minor versions
- PostgreSQL version 11.19 on Amazon RDS
- PostgreSQL version 11.18 on Amazon RDS
- PostgreSQL version 11.17 on Amazon RDS
- PostgreSQL version 11.16 on Amazon RDS
- PostgreSQL version 11.15 on Amazon RDS
- PostgreSQL version 11.14 on Amazon RDS
- PostgreSQL version 11.13 on Amazon RDS
- PostgreSQL version 11.12 on Amazon RDS
- PostgreSQL version 11.11 on Amazon RDS (deprecated)
- PostgreSQL version 11.10 on Amazon RDS (deprecated)
- PostgreSQL version 11.9 on Amazon RDS (deprecated)
- PostgreSQL version 11.8 on Amazon RDS (deprecated)
- PostgreSQL version 11.7 on Amazon RDS (deprecated)
- PostgreSQL version 11.6 on Amazon RDS (deprecated)
- PostgreSQL version 11.5 on Amazon RDS (deprecated)
- PostgreSQL version 11.4 on Amazon RDS (deprecated)
- PostgreSQL version 11.2 on Amazon RDS (deprecated)
- PostgreSQL version 11.1 on Amazon RDS (deprecated)
PostgreSQL version 11.19 on Amazon RDS
PostgreSQL version 11.19 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the
PostgreSQL 11.19 release
For version information on all extensions, see Extensions supported for RDS for PostgreSQL 11.
PostgreSQL version 11.18 on Amazon RDS
PostgreSQL version 11.18 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the
PostgreSQL 11.18 release
New features and enhancements
PostgreSQL version 11.18 added support for the
tcn
("triggered change notification") extension which generates notification events on table changes via a trigger function calledtriggered_change_notification
. The tcn extension is useful for applications using drivers which support asynchronous notification. This makes it possible to notify all clients if the contents of a table have been changed, enabling them to take appropriate action in near-real time, such as updating a table cache or information display.However, such functionality should only be used with care as it makes all data changes on the table available to all clients (including unprivileged users) through the notification events when they listen on the tcn channel. It is the user’s responsibility to avoid using tcn trigger on a table with sensitive data to avoid information leakage.
This version includes the following changes:
The seg extension version 1.3 is added.
The tcn extension version 1.0 is added.
The orafce extension is updated to 3.24.
The pgaudit extension is updated to 1.3.4.
The pgtap extension is updated to 1.2.0.
The PostGIS dependency GDAL is updated to 3.4.3.
The PostGIS dependency PROJ is updated to 7.0.1.
The wal2json extension is updated to 2.5.
The aws_s3 extension is updated to 1.1.
For version information on all extensions, see Extensions supported for RDS for PostgreSQL 11.
PostgreSQL version 11.17 on Amazon RDS
PostgreSQL version 11.17 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in
PostgreSQL 11.17
This version includes the following change:
The PostGIS extension is updated to 3.1.7
For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.
PostgreSQL version 11.16 on Amazon RDS
PostgreSQL version 11.16 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in
PostgreSQL 11.16
This version also includes the following changes:
The pglogical
extension is updated to 2.4.1. The aws_commons extension is updated to 1.2.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.
PostgreSQL version 11.15 on Amazon RDS
PostgreSQL version 11.15 is now available on Amazon RDS. PostgreSQL version 11.15 contains several improvements that were
announced for PostgreSQL release 11.15
This version also includes the following changes:
The pgaudit
extension is updated to 1.3.3. For information about using this extension with RDS for PostgreSQL, see Logging at the session and object level with the pgaudit extension. The lo
module is updated to version 1.1.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.
PostgreSQL version 11.14 on Amazon RDS
PostgreSQL version 11.14 is now available on Amazon RDS. PostgreSQL version 11.14 contains several improvements that were
announced for PostgreSQL release 11.14
This version also includes the following change:
-
The pg_hint_plan
extension is updated to 1.3.7.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.
PostgreSQL version 11.13 on Amazon RDS
PostgreSQL version 11.13 is now available on Amazon RDS. PostgreSQL version 11.13 contains several improvements that were
announced for PostgreSQL release 11.13
This version also includes the following changes:
For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.
PostgreSQL version 11.12 on Amazon RDS
PostgreSQL version 11.12 is now available on Amazon RDS. PostgreSQL version 11.12 contains several improvements that were
announced for PostgreSQL release 11.12
This version also includes the following change:
-
The orafce
extension is updated to version 3.15.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.
PostgreSQL version 11.11 on Amazon RDS (deprecated)
PostgreSQL version 11.11 is now available on Amazon RDS. PostgreSQL version 11.11
contains several improvements that were announced for PostgreSQL release
11.11
This version also added the following new extension:
-
The pg_bigm
extension version 1.2.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.
PostgreSQL version 11.10 on Amazon RDS (deprecated)
PostgreSQL version 11.10 is now available on Amazon RDS. PostgreSQL version 11.10
contains several improvements that were announced for PostgreSQL release
11.10
For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.
PostgreSQL version 11.9 on Amazon RDS (deprecated)
PostgreSQL version 11.9 is now available on Amazon RDS. PostgreSQL version 11.9
contains several improvements that were announced for PostgreSQL release
11.9
This version also includes the following changes:
-
Added the
aws_s3
extension version 1.1 -
Added the
pg_proctab
extension version 0.0.9 -
Upgraded the
pgaudit
extension to version 1.3.1 -
Upgraded the
pglogical
extension to version 2.2.2 -
Added the
rdkit
extension version 3.8
For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.
PostgreSQL version 11.8 on Amazon RDS (deprecated)
PostgreSQL version 11.8 contains several bug fixes for issues in release 11.7.
For more information on the fixes in PostgreSQL 11.8, see the
PostgreSQL 11.8 documentation
This version also includes the following change:
-
Upgraded the
pg_hint_plan
extension to version 1.3.5.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.
PostgreSQL version 11.7 on Amazon RDS (deprecated)
PostgreSQL version 11.7 contains several bug fixes for issues in release 11.6.
For more information on the fixes in PostgreSQL 11.7, see the
PostgreSQL 11.7 documentation
PostgreSQL version 11.6 on Amazon RDS (deprecated)
PostgreSQL version 11.6 contains several bug fixes for issues in release 11.5.
For more information on the fixes in PostgreSQL 11.6, see the
PostgreSQL documentation
This version also includes the following changes:
-
Upgraded the
pgTAP
extension to version 1.1.0. -
Added the
plprofiler
extension. -
Added to
shared_preload_libraries
support forpg_prewarm
to start automatically.
PostgreSQL version 11.5 on Amazon RDS (deprecated)
PostgreSQL version 11.5 contains several bug fixes for issues in release 11.4.
For more information on the fixes in PostgreSQL 11.5, see the
PostgreSQL documentation
This version also includes the following changes:
-
A new extension
pg_transport
is added. -
The extension
aws_s3
has been updated to support virtual-hosted style requests. For more information, see Amazon S3 path deprecation plan – The rest of the story. -
The
PostGIS
extension is updated to version 2.5.2.
PostgreSQL version 11.4 on Amazon RDS (deprecated)
This release contains an important security fix and also bug fixes and
improvements done by the PostgreSQL community. For more information on the
security fix, see the PostgreSQL community announcement
With this release, the pg_hint_plan
extension has been updated to
version 1.3.4.
For more information on the fixes in PostgreSQL 11.4, see the PostgreSQL
documentation
PostgreSQL version 11.2 on Amazon RDS (deprecated)
PostgreSQL version 11.2 contains several bug fixes for issues in release 11.1.
For more information on the fixes in PostgreSQL 11.2, see the PostgreSQL documentation
This version also includes the following changes:
-
A new pgTAP
extension version 1.0. -
Support for Amazon S3 import. For more information, see Importing Amazon S3 data into an RDS for PostgreSQL DB instance in the Amazon RDS User Guide.
-
Multiple major version upgrade is available to PostgreSQL 11.2 from certain previous PostgreSQL versions. For more information, see Choosing a major version upgrade for PostgreSQL in the Amazon RDS User Guide.
For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.
PostgreSQL version 11.1 on Amazon RDS (deprecated)
PostgreSQL version 11.1 contains several improvements that were announced in
PostgreSQL 11.1
released!
PostgreSQL version 11.1 contains several bug fixes for issues in release 11.
For complete details, see the PostgreSQL
release 11.1 documentation
-
Partitioning – Partitioning improvements include support for hash partitioning, enabling creation of a default partition, and dynamic row movement to another partition based on the key column update.
-
Performance – Performance improvements include parallelism while creating indexes, materialized views, hash joins, and sequential scans to make the operations perform better.
-
Stored procedures – SQL stored procedures now added support embedded transactions.
-
Support for Just-In-Time (JIT) capability – RDS for PostgreSQL 11 instances are created with JIT capability, speeding evaluation of expressions. To enable JIT capability, set the
jit
parameter to 1 in the PostgreSQL parameter group for the database. -
Segment size – The write-ahead logging (WAL) segment size has been changed from 16 MB to 64 MB.
-
Autovacuum improvements – To provide valuable logging, the parameter
rds.force_autovacuum_logging
is ON by default in conjunction with thelog_autovacuum_min_duration
parameter set to 10 seconds. To increase autovacuum effectiveness, the values for theautovacuum_max_workers
andautovacuum_vacuum_cost_limit
parameters are computed based on host memory capacity to provide larger default values. -
Improved transaction timeout – The parameter
idle_in_transaction_session_timeout
is set to 24 hours. Any session that has been idle more than 24 hours is terminated. -
Performance metrics – The
pg_stat_statements
extension is included inshared_preload_libraries
by default. This avoids having to reboot the instance immediately after creation. However, this functionality still requires you to run the statementCREATE EXTENSION pg_stat_statements;
. Also,track_io_timing
is enabled by default to add more granular data topg_stat_statements
. -
The tsearch2 extension is no longer supported – If your application uses
tsearch2
functions, update it to use the equivalent functions provided by the core PostgreSQL engine. For more information about the tsearch2 extension, see PostgreSQL tsearch2. -
The chkpass extension is no longer supported – For more information about the
chkpass
extension, see PostgreSQL chkpass. -
Extension updates for RDS for PostgreSQL 11.1 include the following:
-
pgaudit
is updated to 1.3.0 -
pg_hint_plan
is updated to 1.3.2 -
pglogical
is updated to 2.2.1 -
plcoffee
is updated to 2.3.8 -
plv8
is updated to 2.3.8 -
PostGIS
is updated to 2.5.1 -
prefix
is updated to 1.2.8 -
wal2json
is updated to hash 9e962bad
-
For information on all extensions, see Extensions supported for RDS for PostgreSQL 11.
PostgreSQL 10 versions
Minor versions
- PostgreSQL version 10.23 on Amazon RDS
- PostgreSQL version 10.22 on Amazon RDS
- PostgreSQL version 10.21 on Amazon RDS
- PostgreSQL version 10.20 on Amazon RDS
- PostgreSQL version 10.19 on Amazon RDS
- PostgreSQL version 10.18 on Amazon RDS
- PostgreSQL version 10.17 on Amazon RDS
- PostgreSQL version 10.16 on Amazon RDS (deprecated)
- PostgreSQL version 10.15 on Amazon RDS (deprecated)
- PostgreSQL version 10.14 on Amazon RDS (deprecated)
- PostgreSQL version 10.13 on Amazon RDS (deprecated)
- PostgreSQL version 10.12 on Amazon RDS (deprecated)
- PostgreSQL version 10.11 on Amazon RDS (deprecated)
- PostgreSQL version 10.10 on Amazon RDS (deprecated)
- PostgreSQL version 10.9 on Amazon RDS(deprecated)
- PostgreSQL version 10.7 on Amazon RDS (deprecated)
- PostgreSQL version 10.6 on Amazon RDS (deprecated)
- PostgreSQL version 10.5 on Amazon RDS (deprecated)
- PostgreSQL version 10.4 on Amazon RDS (deprecated)
- PostgreSQL version 10.3 on Amazon RDS (deprecated)
- PostgreSQL version 10.1 on Amazon RDS (deprecated)
PostgreSQL version 10.23 on Amazon RDS
PostgreSQL version 10.23 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in the
PostgreSQL 10.23 release
New features and enhancements
PostgreSQL version 10.23 added support for the
tcn
("triggered change notification") extension which generates notification events on table changes via a trigger function calledtriggered_change_notification
. The tcn extension is useful for applications using drivers which support asynchronous notification. This makes it possible to notify all clients if the contents of a table have been changed, enabling them to take appropriate action in near-real time, such as updating a table cache or information display.However, such functionality should only be used with care as it makes all data changes on the table available to all clients (including unprivileged users) through the notification events when they listen on the tcn channel. It is the user’s responsibility to avoid using tcn trigger on a table with sensitive data to avoid information leakage.
This version includes the following changes:
The seg extension version 1.1 is added.
The tcn extension version 1.0 is added.
The orafce extension is updated to 3.24.
The pgaudit extension is updated to 1.2.4.
PostGIS dependency GDAL is updated to 3.4.3.
PostGIS dependency PROJ is updated to 7.0.1.
The wal2json extension is updated to 2.5.
The aws_s3 extension is updated to 1.1.
For version information on all extensions, see Extensions supported for RDS for PostgreSQL 10.
PostgreSQL version 10.22 on Amazon RDS
PostgreSQL version 10.22 is now available on Amazon RDS. This release contains several fixes and improvements for PostgreSQL announced in
PostgreSQL 10.22
This version includes the following change:
The PostGIS extension is updated to 3.1.7
For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.
PostgreSQL version 10.21 on Amazon RDS
PostgreSQL version 10.21 is now available on Amazon RDS. This release contains several fixes and improvements that were announced in
PostgreSQL 10.21
This version also includes the following changes:
The pglogical
extension is updated to 2.4.1. The aws_commons extension is updated to 1.2.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.
PostgreSQL version 10.20 on Amazon RDS
PostgreSQL version 10.20 is now available on Amazon RDS. PostgreSQL version 10.20 contains several improvements that were
announced for PostgreSQL release 10.20
This version also includes the following changes:
The pgaudit
extension is updated to 1.2.3. For information about using this extension with RDS for PostgreSQL, see Logging at the session and object level with the pgaudit extension in the Amazon RDS User Guide. The lo
module is updated to version 1.1.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.
PostgreSQL version 10.19 on Amazon RDS
PostgreSQL version 10.19 is now available on Amazon RDS. PostgreSQL version 10.19 contains several improvements that were
announced for PostgreSQL release 10.19
This version also includes the following change:
-
The pg_hint_plan
extension is updated to 1.3.6.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.
PostgreSQL version 10.18 on Amazon RDS
PostgreSQL version 10.18 is now available on Amazon RDS. PostgreSQL version 10.18 contains several improvements that were
announced for PostgreSQL release 10.18
This version also includes the following changes:
For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.
PostgreSQL version 10.17 on Amazon RDS
PostgreSQL version 10.17 is now available on Amazon RDS. PostgreSQL version 10.17 contains several improvements that were
announced for PostgreSQL release 10.17
This version also includes the following change:
-
The orafce
extension is updated to version 3.15.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.
PostgreSQL version 10.16 on Amazon RDS (deprecated)
PostgreSQL version 10.16 is now available on Amazon RDS. PostgreSQL version 10.16
contains several improvements that were announced for PostgreSQL release
10.16
For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.
PostgreSQL version 10.15 on Amazon RDS (deprecated)
PostgreSQL version 10.15 is now available on Amazon RDS. PostgreSQL version 10.15
contains several improvements that were announced for PostgreSQL release
10.15
For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.
PostgreSQL version 10.14 on Amazon RDS (deprecated)
PostgreSQL version 10.14 is now available on Amazon RDS. PostgreSQL version 10.14
contains several improvements that were announced for PostgreSQL release
10.14
This version also includes the following changes:
-
Added the
aws_s3
extension version 1.1. For more information, see Exporting data from an RDS for PostgreSQL DB instance to Amazon S3 in the Amazon RDS User Guide. -
Upgraded the
pgaudit
extension to version 1.2.1 -
Upgraded the
pglogical
extension to version 2.2.2 -
Upgraded the
wal2json
extension to version 2.3
For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.
PostgreSQL version 10.13 on Amazon RDS (deprecated)
PostgreSQL version 10.13 contains several bug fixes for issues in release 10.12.
For more information on the fixes in PostgreSQL 10.13, see the
PostgreSQL 10.13 documentation
This version also includes the following change:
-
Upgraded the
pg_hint_plan
extension to version 1.3.5.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 10.
PostgreSQL version 10.12 on Amazon RDS (deprecated)
PostgreSQL version 10.12 contains several bug fixes for issues in release 10.11.
For more information on the fixes in PostgreSQL 10.12, see the
PostgreSQL 10.12 documentation
PostgreSQL version 10.11 on Amazon RDS (deprecated)
PostgreSQL version 10.11 contains several bug fixes for issues in release
10.10. For more information on the fixes in PostgreSQL 10.11, see the PostgreSQL
documentation
-
Added the
plprofiler
extension.
PostgreSQL version 10.10 on Amazon RDS (deprecated)
PostgreSQL version 10.10 contains several bug fixes for issues in release
10.9. For more information on the fixes in PostgreSQL 10.10, see the PostgreSQL
documentation
-
The
aws_s3
extension is updated to support virtual-hosted style requests. For more information, see Amazon S3 path deprecation plan – The rest of the story. -
The
The PostGIS
extension is updated to version 2.5.2.
PostgreSQL version 10.9 on Amazon RDS(deprecated)
This release contains an important security fix and also bug fixes and
improvements done by the PostgreSQL community. For more information on the
security fix, see the PostgreSQL community announcement
With this release, the pg_hint_plan
extension has been updated to version 1.3.3.
For more information on the fixes in PostgreSQL 10.9, see the PostgreSQL documentation
PostgreSQL version 10.7 on Amazon RDS (deprecated)
PostgreSQL version 10.7 contains several bug fixes for issues in release 10.6.
For more information on the fixes in 10.7, see the PostgreSQL
documentation
This version also includes the following changes:
-
Support for Amazon S3 import. For more information, see Importing Amazon S3 data into an RDS for PostgreSQL DB instance in the Amazon RDS User Guide.
-
Multiple major version upgrade is available to PostgreSQL 10.7 from certain previous PostgreSQL versions. For more information, see Choosing a major version upgrade for PostgreSQL in the Amazon RDS User Guide.
For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.
PostgreSQL version 10.6 on Amazon RDS (deprecated)
PostgreSQL version 10.6 contains several bug fixes for issues in release 10.5.
For more information on the fixes in PostgreSQL 10.6, see the PostgreSQL
documentation
This version also includes the following changes:
-
A new
rds.restrict_password_commands
parameter and a newrds_password
role have been introduced. When therds.restrict_password_commands
parameter is enabled, only users who have therds_password
role can make user password and password expiration changes. By restricting password-related operations to a limited set of roles, you can implement policies such as password complexity requirements from the client side. Therds.restrict_password_commands
parameter is static, so it requires a database restart to change it. For more information, see Restricting password management in the Amazon RDS User Guide. -
The logical decoding plugin
wal2json
has been updated to commit9e962ba
.
For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.
For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.
Amazon RDS for PostgreSQL has announced the removal of the
tsearch2
extension in the next major release. We encourage
customers still using pre-8.3 text search to migrate to the equivalent
built-in features. For more information about migrating, see the PostgreSQL documentation
PostgreSQL version 10.5 on Amazon RDS (deprecated)
PostgreSQL version 10.5 contains several bug fixes for issues in release 10.4.
For more information on the fixes in 10.5, see the PostgreSQL
documentation
This version also includes the following changes:
-
Support for the
pglogical
extension version 2.2.0. Prerequisites for using this extension are the same as the prerequisites for using logical replication for PostgreSQL as described in Performing logical replication for Amazon RDS for PostgreSQL in the Amazon RDS User Guide. -
Support for the
pg_similarity
extension version 1.0. -
Support for the
pageinspect
extension version 1.6. -
Support for the
libprotobuf
extension version 1.3.0 for the PostGIS component. -
An update for the
pg_hint_plan
extension to version 1.3.1. -
An update for the
wal2json
extension to version 01c5c1e.
For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.
For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.
PostgreSQL version 10.4 on Amazon RDS (deprecated)
PostgreSQL version 10.4 contains several bug fixes for issues in release 10.3.
For more information on the fixes in 10.4, see the PostgreSQL
documentation
This version also includes the following changes:
-
Support for PostgreSQL 10 Logical Replication using the native publication and subscription framework. RDS for PostgreSQL databases can function as both publishers and subscribers. You can specify replication to other PostgreSQL databases at the database-level or at the table-level. With logical replication, the publisher and subscriber databases need not be physically identical (block-to-block) to each other. This allows for use cases such as data consolidation, data distribution, and data replication across different database versions for 10.4 and above. For more information, see Performing logical replication for Amazon RDS for PostgreSQL in the Amazon RDS User Guide.
-
The temporary file size limitation is user-configurable. You require the rds_superuser role to modify the
temp_file_limit
parameter. -
Update of the
GDAL
library, which is used by the PostGIS extension. See Managing spatial data with the PostGIS extension in the Amazon RDS User Guide. -
Update of the
ip4r
extension to version 2.1.1. -
Update of the
pg_repack
extension to version 1.4.3. See Working with the pg_repack extension in the Amazon RDS User Guide. -
Update of the
plv8
extension to version 2.1.2.
For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.
For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.
The tsearch2
extension is to be removed in the next major
release. We encourage customers still using pre-8.3 text search to migrate
to the equivalent built-in features. For more information about migrating,
see the PostgreSQL documentation
PostgreSQL version 10.3 on Amazon RDS (deprecated)
PostgreSQL version 10.3 contains several bug fixes for issues in release 10.
For more information on the fixes in 10.3, see the PostgreSQL
documentation
Version 2.1.0 of plv8 is now available. If you use plv8 and upgrade PostgreSQL to a new plv8 version, you immediately take advantage of the new extension but the catalog metadata doesn't reflect this fact. For the steps to synchronize your catalog metadata with the new version of plv8, see Upgrading PLV8 in the Amazon RDS User Guide.
For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.
For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.
PostgreSQL version 10.1 on Amazon RDS (deprecated)
PostgreSQL version 10.1 contains several bug fixes for issues in release 10.
For more information on the fixes in 10.1, see the PostgreSQL
documentation
For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.
PostgreSQL version 10.1 includes the following changes:
-
Declarative table partitioning – PostgreSQL 10 adds table partitioning to SQL syntax and native tuple routing.
-
Parallel queries – When you create a new PostgreSQL 10.1 instance, parallel queries are enabled for the
default.postgres10
parameter group. The parameter max_parallel_workers_per_gatheris set to 2 by default, but you can modify it to support your specific workload requirements. -
Support for the international components for unicode (ICU) – You can use the ICU library to provide explicitly versioned collations. Amazon RDS for PostgreSQL 10.1 is compiled with ICU version 60.2. For more information about ICU implementation in PostgreSQL, see Collation support
. -
Huge pages – Huge pages is a feature of the Linux kernel that uses multiple page size capabilities of modern hardware architectures. Amazon RDS for PostgreSQL supports huge pages with a global configuration parameter. When you create a new PostgreSQL 10.1 instance with RDS, the
huge_pages
parameter is set to"on"
for thedefault.postgres10
parameter group. You can modify this setting to support your specific workload requirements. -
Extension plv8 update – plv8 is a procedural language that you can use to write functions in JavaScript that you can then call from SQL. This release of PostgreSQL supports version 2.1.0 of plv8.
-
Renaming of xlog and location – In PostgreSQL version 10 the abbreviation "xlog" has changed to "wal", and the term "location" has changed to "lsn". For more information, see https://www.postgresql.org/docs/10/static/release-10.html#id-1.11.6.8.4
. -
tsearch2 extension – Amazon RDS continues to provide the
tsearch2
extension in PostgreSQL version 10, but is to remove it in the next major version release. If your application uses tsearch2 functions update it to use the equivalent functions the core engine provides. For more information see tsearch2in the PostgreSQL documentation.
For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.
PostgreSQL 9.6 versions (deprecated)
Minor versions
- PostgreSQL version 9.6.24 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.23 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.22 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.21 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.20 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.19 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.18 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.17 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.16 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.15 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.14 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.12 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.11 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.10 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.9 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.8 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.6 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.5 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.3 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.2 on Amazon RDS (deprecated)
- PostgreSQL version 9.6.1 on Amazon RDS (deprecated)
PostgreSQL version 9.6.24 on Amazon RDS (deprecated)
PostgreSQL version 9.6.24 is now available on Amazon RDS. PostgreSQL version 9.6.24 contains several improvements that were
announced for PostgreSQL release 9.6.24
This version also includes the following change:
-
The pg_hint_plan
extension is updated to 1.2.7.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 9.6 .
PostgreSQL version 9.6.23 on Amazon RDS (deprecated)
PostgreSQL version 9.6.23 is now available on Amazon RDS. PostgreSQL version 9.6.23 contains several improvements that were
announced for PostgreSQL release 9.6.23
This version also includes the following changes:
-
The
pglogical
extension is updated to version 2.4.0. -
The PostGIS extension is updated to version 2.5.5, along with the following related extensions:
For information on all extensions, see Extensions supported for RDS for PostgreSQL 9.6 .
PostgreSQL version 9.6.22 on Amazon RDS (deprecated)
PostgreSQL version 9.6.22 is now available on Amazon RDS. PostgreSQL version 9.6.22 contains several improvements that were
announced for PostgreSQL release 9.6.22
This version also includes the following change:
-
The orafce
extension is updated to version 3.15.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 9.6 .
PostgreSQL version 9.6.21 on Amazon RDS (deprecated)
PostgreSQL version 9.6.21 is now available on Amazon RDS. PostgreSQL version 9.6.21
contains several improvements that were announced for PostgreSQL release
9.6.21
For information on all extensions, see Extensions supported for RDS for PostgreSQL 9.6 .
PostgreSQL version 9.6.20 on Amazon RDS (deprecated)
PostgreSQL version 9.6.20 is now available on Amazon RDS. PostgreSQL version 9.6.20
contains several improvements that were announced for PostgreSQL release
9.6.20
For information on all extensions, see Extensions supported for RDS for PostgreSQL 9.6 .
PostgreSQL version 9.6.19 on Amazon RDS (deprecated)
PostgreSQL version 9.6.19 is now available on Amazon RDS. PostgreSQL version 9.6.19
contains several improvements that were announced for PostgreSQL release
9.6.19
This version also includes the following changes:
-
Upgraded the
pgaudit
extension to version 1.1.2 -
Upgraded the
pglogical
extension to version 2.2.2 -
Upgraded the
wal2json
extension to version 2.3
For information on all extensions, see Extensions supported for RDS for PostgreSQL 9.6 .
PostgreSQL version 9.6.18 on Amazon RDS (deprecated)
PostgreSQL version 9.6.18 contains several bug fixes for issues in release 9.6.17.
For more information on the fixes in PostgreSQL 9.6.18, see the
PostgreSQL 9.6.18 documentation
This version also includes the following change:
-
Upgraded the
pg_hint_plan
extension to version 1.2.6.
For information on all extensions, see Extensions supported for RDS for PostgreSQL 9.6 .
PostgreSQL version 9.6.17 on Amazon RDS (deprecated)
PostgreSQL version 9.6.17 contains several bug fixes for issues in release 9.6.16.
For more information on the fixes in PostgreSQL 9.6.17, see the
PostgreSQL 9.6.17 documentation
PostgreSQL version 9.6.16 on Amazon RDS (deprecated)
PostgreSQL version 9.6.16 contains several bug fixes for issues in release
9.6.15. For more information on the fixes in PostgreSQL 9.6.16, see the
PostgreSQL documentation
PostgreSQL version 9.6.15 on Amazon RDS (deprecated)
PostgreSQL version 9.6.15 contains several bug fixes for issues in release 9.6.14.
For more information on the fixes in PostgreSQL 9.6.15, see the
PostgreSQL documentation
The PostGIS
extension is updated to version 2.5.2.
PostgreSQL version 9.6.14 on Amazon RDS (deprecated)
This release contains bug fixes and improvements done by the PostgreSQL community.
With this release, the pg_hint_plan
extension has been updated to version 1.2.5.
For more information on the fixes in PostgreSQL 9.6.14, see the PostgreSQL documentation
PostgreSQL version 9.6.12 on Amazon RDS (deprecated)
PostgreSQL version 9.6.12 contains several bug fixes for issues in release
9.6.11. For more information on the fixes in 9.6.12, see the
PostgreSQL
documentation
For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.
PostgreSQL version 9.6.11 on Amazon RDS (deprecated)
PostgreSQL version 9.6.11 contains several bug fixes for issues in release
9.6.10. For more information on the fixes in PostgreSQL 9.6.11, see the PostgreSQL documentation
With this version, the logical decoding plugin wal2json
has been
updated to commit 9e962ba
.
For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.
PostgreSQL version 9.6.10 on Amazon RDS (deprecated)
PostgreSQL version 9.6.10 contains several bug fixes for issues in release
9.6.9. For more information on the fixes in 9.6.10, see the PostgreSQL documentation
This version includes the following changes:
-
Support for the
pglogical
extension version 2.2.0. Prerequisites for using this extension are the same as the prerequisites for using logical replication for PostgreSQL as described in Performing logical replication for Amazon RDS for PostgreSQL in the Amazon RDS User Guide. -
Support for the
pg_similarity
extension version 2.2.0. -
An update for the
wal2json
extension to version 01c5c1e. -
An update for the
pg_hint_plan
extension to version 1.2.3.
For information on upgrading the engine version for your PostgreSQL DB instance, see Upgrading the PostgreSQL DB engine for Amazon RDS in the Amazon RDS User Guide.
For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.
PostgreSQL version 9.6.9 on Amazon RDS (deprecated)
PostgreSQL version 9.6.9 contains several bug fixes for issues in release
9.6.8. For more information on the fixes in 9.6.9, see the PostgreSQL documentation
This version includes the following changes:
-
The temporary file size limitation is user-configurable. You require the rds_superuser role to modify the
temp_file_limit
parameter. -
Update of the
GDAL
library, which is used by the PostGIS extension. See Working with the PostGIS extension in the Amazon RDS User Guide. -
Update of the
ip4r
extension to version 2.1.1. -
Update of the
pgaudit
extension to version 1.1.1. See Logging at the session and object level with the pgaudit extension in the Amazon RDS User Guide.Update of the
pg_repack
extension to version 1.4.3. See Working with the pg_repack extension in the Amazon RDS User Guide. -
Update of the
plv8
extension to version 2.1.2.
For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.
PostgreSQL version 9.6.8 on Amazon RDS (deprecated)
PostgreSQL version 9.6.8 contains several bug fixes for issues in release
9.6.6. For more information on the fixes in 9.6.8, see the PostgreSQL documentation
For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.
PostgreSQL version 9.6.6 on Amazon RDS (deprecated)
PostgreSQL version 9.6.6 contains several bug fixes for issues in release
9.6.5. For more information on the fixes in 9.6.6, see the PostgreSQL documentation
This version includes the following features:
-
Supports the
orafce
extension, version 3.6.1. This extension contains functions that are native to commercial databases, and can be helpful if you are porting a commercial database to PostgreSQL. For more information about usingorafce
with Amazon RDS, see Using functions from the orafce extensionin the Amazon RDS User Guide. -
Supports the
prefix
extension, version 1.2.6. This extension provides an operator for text prefix searches. For more information aboutprefix
, see the prefix project on GitHub. -
Supports version 2.3.4 of PostGIS, version 2.4.2 of pgrouting
, and an updated version of wal2json.
For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.
PostgreSQL version 9.6.5 on Amazon RDS (deprecated)
PostgreSQL version 9.6.5 contains several bug fixes for issues in release
9.6.4. For more information on the fixes in 9.6.5, see the PostgreSQL documentation
This version also includes support for the pgrouting
For the complete list of extensions supported by Amazon RDS for PostgreSQL, see Extension versions for Amazon RDS for PostgreSQL.
PostgreSQL version 9.6.3 on Amazon RDS (deprecated)
PostgreSQL version 9.6.3 contains several new features and bug fixes. This version includes the following features:
-
Supports the extension
pg_repack
version 1.4.0. You can use this extension to remove bloat from tables and indexes. For more information on usingpg_repack
with Amazon RDS, see Reducing bloat in tables and indexes with the pg_repack extension in the Amazon RDS User Guide. -
Supports the extension
pgaudit
version 1.1.0. This extension provides detailed session and object audit logging. For more information on using pgaudit with Amazon RDS, see Logging at the session and object level with the pgaudit extension in the Amazon RDS User Guide. -
Supports
wal2json
, an output plugin for logical decoding. -
Supports the
auto_explain
extension. You can use this extension to log execution plans of slow statements automatically. The following example shows how to useauto_explain
from within an Amazon RDS PostgreSQL session:LOAD '$libdir/plugins/auto_explain';
For more information on using
auto_explain
, see the PostgreSQL documentation.
PostgreSQL version 9.6.2 on Amazon RDS (deprecated)
PostgreSQL version 9.6.2 contains several new features and bug fixes. The new version also includes the following extension versions:
-
PostGIS version 2.3.2
-
pg_freespacemap
version 1.1–Provides a way to examine the free space map (FSM). This extension provides an overloaded function called pg_freespace. The functions show the value recorded in the free space map for a given page, or for all pages in the relation. -
pg_hint_plan
version 1.1.3– Provides control of execution plans by using hinting phrases at the beginning of SQL statements. -
log_fdw version 1.0–Using this extension from Amazon RDS, you can load and query your database engine log from within the database. For more information, see Using the log_fdw extension to access the DB log using SQL in the Amazon RDS User Guide.
-
With this version release, you can now edit the
max_worker_processes
parameter in a DB parameter group.
PostgreSQL version 9.6.2 on Amazon RDS also supports altering enum values. For more information, see Custom data types and enumerations with RDS for PostgreSQL in the Amazon RDS User Guide.
For more information on the fixes in 9.6.2, see the PostgreSQL documentation
PostgreSQL version 9.6.1 on Amazon RDS (deprecated)
PostgreSQL version 9.6.1 contains several new features and improvements. For
more information about the fixes and improvements in PostgreSQL 9.6.1, see the
PostgreSQL documentation
PostgreSQL version 9.6.1 includes the following changes:
-
Parallel query processing: Supports parallel processing of large read-only queries, allowing sequential scans, hash joins, nested loops, and aggregates to be run in parallel. By default, parallel query processing isn't enabled. To enable parallel query processing, set the parameter
max_parallel_workers_per_gather
to a value larger than zero.
-
Updated postgres_fdw extension: Supports remote JOINs, SORTs, UPDATEs, and DELETE operations.
-
plv8 update: Provides version 1.5.3 of the plv8 language.
-
PostGIS version update: Supports POSTGIS="2.3.0 r15146" GEOS="3.5.0-CAPI-1.9.0 r4084" PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 2.1.1, released 2016/07/07" LIBXML="2.9.1" LIBJSON="0.12" RASTER
-
Vacuum improvement: Avoids scanning pages unnecessarily during vacuum freeze operations.
-
Full-text search support for phrases: Supports the ability to specify a phrase-search query in tsquery input using the new operators <-> and <N>.
-
Two new extensions are supported:
-
bloom
, an index access method based on Bloom filters -
pg_visibility
, which provides a means for examining the visibility map and page-level visibility information of a table.
-
-
With the release of version 9.6.2, you can now edit the
max_worker_processes
parameter in a PostgreSQL version 9.6.1 DB parameter group.