I am trying to upgrade My postgres DBs from postgres 10 to 14, after looking at the extension version here https://docs.aws.amazon.com/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html#postgresql-extensions-14x I need to upgrade postgres_fdw to 1.1.
However I am getting the below error when i run the upgrade command.
ALTER EXTENSION postgres_fdw UPDATE TO '1.1'
SQL Error [22023]: ERROR: extension "postgres_fdw" has no update path from version "1.0" to version "1.1"