Posted On: May 31, 2018
PostgreSQL 11 Beta 1 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. The PostgreSQL community released PostgreSQL 11 Beta 1 on May 24, 2018. PostgreSQL 11 Beta 1 includes SQL stored procedures that allow embedded transactions within a procedure. PostgreSQL 11 Beta 1 also includes major improvements to partitioning, improvements to parallelism, and many other useful performance improvements like adding columns with a non-null column default faster.
The Amazon RDS Database Preview Environment supports both Single-AZ and Multi-AZ deployments on the latest generation of instance classes (currently 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 11 and the Amazon RDS Database Preview Environment.