Major Version Upgrade Aurora PostgreSQL 11
Hope you are well.
I have a question on "Major version upgrade" activity in Aurora PostgreSQL. I know why AWS does not manage the 'PostgreSQL Major Version Upgrade' because it does not have backward compatibility and has application dependencies.
in-line upgrade (pg_upgrade) is not managed by AWS in Aurora PostgreSQL ( unlike minor version upgrade).
export / import (pg_dump,restore) : Create another Aurora Cluster with Higher version (target) and export from lower version of Aurora PostgreSQL (Source, let's say ver10) and import to Higher version (let's say Ver 11).For BIG sized database it takes long time and downtime will be high,
Replication by DMS : For BIG sized database, it is always an overhead of almost every time whenever there is a newer major version (10>11>12).
What's the more advisable way of doing that keeping in mind the database size is 30TB of data?
Is there any plan for AWS to manage Major Version Upgrade at present or future like auto minor version upgrade ? https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.PostgreSQL.html
We currently support in-place major version upgrade for Aurora PostgreSQL 9.6 to 10 as part of the Aurora PostgreSQL console and API; we are working to add support for 10 to 11 later this year.
-Kevin J (PM for Aurora PostgreSQL)
Hi Kevin ,
Thanks for the response. Will AWS also support in-place major version upgrade for Aurora PostgreSQL 11 to 12 ( Once Version 12 is available in Aurora). ? Or in future does it support in-place major version upgrade for Aurora PostgreSQL from any major version to other major version?
This will make our strategy to move to Aurora PostgreSQL more clear which lead to better decision to move to Aurora PostgreSQL.
Edited by: DipankarAws100Per on Jul 7, 2020 3:59 PM
In general, we target supporting in-place major version upgrade (MVU) between PostgreSQL major versions for both Aurora PostgreSQL and RDS for PostgreSQL. We are targeting support for MVU to all supported major versions of PostgreSQL in Aurora PostgreSQL, and when we add support for a new major version, we will add support for MVU to that version either concurrently or as soon as possible afterwards.
Thanks very much
Major Version Upgrades in Aurora Cluster With Replicas - Can it be done in batches ?Accepted Answerasked 5 months ago
Upgrade for Amazon Aurora Serverless v1 PostgreSQL-compatible edition 10.x end of support is January 31, 2023asked 3 months ago
[Announcement] Extending end-of-life process for Amazon RDS for PostgreSQL 9.6asked 6 months ago
[Announcement] Amazon Aurora PostgreSQL 9.6 End of life is January 31, 2022asked a year ago
aurora postgres major upgrade - pg_dumpallasked 3 years ago
Announcement: Amazon Aurora PostgreSQL 10.x end of support is January 31, 2023asked 5 months ago
RDS PostgreSQL minor version upgrade wasn't performedasked 3 years ago
AWS automatic upgrade PostgreSQL version?asked 2 months ago
Move RDS postgresql database to Aurora ServerlessAccepted Answerasked 3 years ago
Major Version Upgrade Aurora PostgreSQL 11asked 2 years ago