postgresql - postgres 从 10.9 升级到 11.4 失败 (aws rds)

Question

由于以下原因导致 aws rds 失败，postgres 从 10.9 升级到 11.4

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.

我安装了 postgis 2.4.4 和命令

ALTER EXTENSION postgis UPDATE; 

失败并显示消息

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

和命令

ALTER EXTENSION postgis UPDATE TO "2.5.1"

失败并显示此消息

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

Answer 1

为了升级到版本 2.5.*，您需要运行以下命令

更改扩展 postgis 更新为“2.5.2”；