Major Version Upgrade Aurora PostgreSQL 11

0

Hi,
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.

Option(s):

[1]in-line upgrade (pg_upgrade) is not managed by AWS in Aurora PostgreSQL ( unlike minor version upgrade).

[2]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,

[3]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

Thanks,

asked 4 years ago1528 views
4 Answers
0

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)

answered 4 years ago
0

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.
Thanks,

Edited by: DipankarAws100Per on Jul 7, 2020 3:59 PM

answered 4 years ago
0

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.

answered 4 years ago
0

Thanks very much

answered 4 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions