CODEWITHSUNDEEP
postgresqlamazon-web-servicesamazon-aurora
Avraam Mavridis
Avraam Mavridis

Reputation: 8920

Aurora Postgres Minor Version Upgrade

AWS requests upgrading Aurora Postgres from 12.4 to 12.7, I am trying to understand if there will be downtime during this upgrade and how I can avoid it but unfortunately I cannot find a clear answer. What is the suggested way to avoid downtime or at least minimise the duration?

Upvotes: 1

Views: 2784

Answers (2)

Satya
Satya

Reputation: 21

AWS recently introduced Zero-downtime-patching, for Aurora PostgreSQL (regional) clusters.

But not applicable for Aurora Serverless and Aurora global databases, so there will be downtime in these cases, depending on cluster setup.

Upvotes: 0

stdunbar
stdunbar

Reputation: 17455

Amazon documents the overall process and tells you how to do it manually if you want. When I upgrade a local PostgreSQL instance the minor upgrade process is extremely quick but there isn't a guarantee that the RDS version will be as fast, especially depending on your configuration (multi AZ, read replicas, etc.). I doubt the downtime will be zero but, again, your setup is the big factor.

Upvotes: 1

Related Questions