Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Upgrade RDS Postgres from 11.19 to 15.2 takes enormous amount of time

1

I am trying to upgrade an RDS Postgres instance from 11.19 to 15.2. My db is almost empty, with allocated 100GB and used ~1GB.

I would expect the upgrade to be almost seemless, taking at most 5 minutes, but after waiting for more than 1.5 hour, I deleted the instance.

Is there something that I didn't notice that caused this much time of waiting for this upgrade?

Topics
AnalyticsMigration & ModernizationDatabase
Tags
Amazon Relational Database ServicePostgreSQLDatabase
Language
English
asked 3 years ago3.4K views
1 Answer
1
Accepted Answer

I found the issue by issuing step by step upgrades for each major version. When upgrading from latest 11 to latest 12, an error was thrown (and upgrade aborted) about having tables using unsupported WITH OIDS conditions. After deleting those tables, the upgrade from 11 to 15 took less than 2 minutes (as expected).

However, the issue was that direct upgrade from 11 to 15 did not throw those errors, instead it simply got stuck.

answered 3 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.

Relevant content