The most prominent were the introduction of row – level security and Block Range Indexes (BRIN). PostgreSQL 9.5 had significant features in its release. For instructions, see Upgrading the PostgreSQL DB Engine for Amazon RDS.
#REASON 9.5 UPGRADE UPGRADE#
If any PostgreSQL 9.5 instances are in your account, you can upgrade them before March 16, 2021. For example, see the following code:Įxport ENDPOINT= Īws rds describe-db-engine-versions -engine postgres -region $REGION -endpoint $ENDPOINT -output text -query '*.ValidUpgradeTarget.' You can also get the list of all valid upgrade targets using the describe-db-engine-versions– CLI command. To find out if you have any 9.5 instances in a given Region, on the Amazon RDS console, navigate to the Depreciated major versions section on the Recommendations page. We highly recommend upgrading any Amazon RDS for PostgreSQL 9.5 databases before March 16, 2021, to allow time to test your applications. On Ma00:00:01 AM UTC, any PostgreSQL 9.5 databases that remain will be upgraded to version 12 regardless of whether the instances are in a maintenance window or not. If you do not upgrade your databases before February 16, 2021, RDS will upgrade your PostgreSQL 9.5 databases to PostgreSQL 12 during a scheduled maintenance window between 00:00:01 UTC and Ma00:00:01 UTC. To encourage the use of newer versions of PostgreSQL, on February 16, 2020, Amazon RDS for PostgreSQL will stop supporting the creation of new PostgreSQL 9.5 instances from the AWS Management Console or AWS Command Line Interface (AWS CLI). The PostgreSQL community version 9.5 will reach EOL on February 11, 2021. Therefore, it’s important to retire unsupported major versions in tandem with the community, and we encourage you to upgrade to newer versions as early as possible and validate your applications before automatic upgrades begin. After the community stops supporting a major version, you’re at the risk of being exposed to one of these high – severity bugs.
Preparing to upgradeĪmazon Relational Database Service (Amazon RDS) for PostgreSQL relies on the open-source community to fix critical security, availability and data correctness issues in the database engine. The next major version to reach EOL is 9.5, which is happening on February 11, 2021. For the final release dates of all versions of PostgreSQL, see Versioning Policy. After the fifth year, a major version has one final minor release containing any fixes, and is then considered EOL and no longer supported. The community EOL policy is to support a major version for 5 years after its initial release. This allows you to make version and upgrade decisions well into the future. The PostgreSQL – community releases a new major version yearly, with a defined end of life (EOL) policy of older major versions. Updated on with more details about the automatic upgrade and its timeline.
0 kommentar(er)
