Posted On: Nov 6, 2019
PostgreSQL 12.0 can now be deployed for development and testing in the Amazon RDS Database Preview Environment without the hassle of installing, provisioning, and managing the database software. This release includes support for 51 extensions including PostGIS 3.0.0alpha3, and also adds support for the wal2json and decoder_raw plugins for logical decoding.
The PostgreSQL community released PostgreSQL 12.0 on October 3, 2019. PostgreSQL 12 includes improved functionality, performance, management of indexing, improved partitioning capabilities, JSON path queries per SQL/JSON specifications, nondeterministic collations which support case-insensitive and accent-insensitive comparisons for ICU provided collations, most common-value statistics for improved query plans, creation of generated columns that computes values with an expression, pluggable table storage interface, ability to enable/disable page checksums, and many additional features.
The Amazon RDS Database Preview Environment now supports both Single-AZ and Multi-AZ deployments on the latest generation of instance classes (T3, M5 and R5) along with previous generation (T2, M4, and R4), and can be encrypted at rest using KMS keys. Amazon RDS Database Preview Environment database instances are retained for a maximum period of 60 days and are automatically deleted after the retention period. Amazon RDS database snapshots that are created in the preview environment can only be used to create or restore database instances within the preview environment. Customers can use standard PostgreSQL dump and load functionality to import or export their databases from the preview environment.
Amazon RDS Database Preview Environment database instances are priced the same as production RDS instances created in the US East (Ohio) Region.
The Amazon RDS Database Preview Environment Forum is available for customers and the Amazon RDS team to share information and concerns about both the candidate versions of PostgreSQL 12 and the Amazon RDS Database Preview Environment.