postgres upgrade from 10.9 to 11.4 failure (aws rds)

Question

postgres upgrade from 10.9 to 11.4 on aws rds failure with below reason

Database instance is in a state that cannot be upgraded: PreUpgrade checks failed: The instance could not be upgraded because there are one or more databases with an older version of PostGIS installed. Please upgrade all installations of PostGIS and try again.

i have postgis 2.4.4 installed and command

ALTER EXTENSION postgis UPDATE;

fails with message

NOTICE: version "2.4.4" of extension "postgis" is already installed

and command

ALTER EXTENSION postgis UPDATE TO "2.5.1"

fails with this message

extension "postgis" has no update path from version "2.4.4" to version "2.5.1"

pls select my answer if it helped. Thanks.

S.S.Prabhu
– S.S.Prabhu

2022-04-08 06:13:40 +00:00
Commented Apr 8, 2022 at 6:13 — S.S.Prabhu
– S.S.Prabhu, Commented Apr 8, 2022 at 6:13

Mahdi Yusuf · Accepted Answer · 2020-03-24 23:12:19Z

4

In order to upgrade to version 2.5.* you need to run the following command

ALTER EXTENSION postgis UPDATE TO "2.5.2";

answered Mar 24, 2020 at 23:12

Mahdi Yusuf

21.2k29 gold badges77 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

pje Over a year ago

As a clarification, this is because AWS RDS supports specific versions of PostgreSQL extensions. In this case, the PostGIS version that is supported for v10 is 2.5.2. This is in this table in the AWS documentation: docs.aws.amazon.com/AmazonRDS/latest/UserGuide/…

Gurmokh Over a year ago

You cannot run this statement on his db as versions over 2.4.4 are not supported.

S.S.Prabhu · Accepted Answer · 2022-02-18 13:39:10Z

1

It gives you that error because there is no upgrade from 2.4.4 to 2.5.1. You can only move to 2.5.2 as next step.

Refer to this page under section "PostgreSQL version 10.x extensions supported on Amazon RDS".

And similarly if you wanted to go to 3.1.4 from 2.4.4, you must first go to 2.5.2 and then to 3.1.4.

answered Feb 18, 2022 at 13:39

S.S.Prabhu

9910 bronze badges

1 Comment

S.S.Prabhu Over a year ago

@Vinesh, pls select my answer if it helped.

Collectives™ on Stack Overflow

postgres upgrade from 10.9 to 11.4 failure (aws rds)

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related