Postgres database upgrade failed (11.6 - 13.7)

Question

Postgres database upgrade failed (11.6 -> 13.7) with error:
*pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 6052; 1259 720106 INDEX unq_nickname_ci dba
pg_restore: error: could not execute query: ERROR:  function public.unaccent(unknown, text) does not exist
LINE 3: SELECT public.unaccent('public.unaccent', $1)  -- schema-qua...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.*

After the first failed upgrade, the index and function were deleted, so they don't exist in the catalog, but subsequent upgrades still ends with the same error. Do you have any idea how to proceed?

Brandon · Answer

Hi there,

Can you run this command and see which targets are available for your current version:
aws rds describe-db-engine-versions

--engine postgres

--engine-version 11.6

--query "DBEngineVersions[].ValidUpgradeTarget[].{EngineVersion:EngineVersion}" --output text

Version 11.6 is currently not available on AWS so you may have to upgrade via the CLI, if you're not already. Follow this guide to ensure all requirements are met - https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.PostgreSQL.html#USER_UpgradeDBInstance.PostgreSQL.MajorVersion

The command to upgrade is seen when you expand the AWS CLI toggle as seen below: 
aws rds modify-db-cluster
--db-cluster-identifier mydbcluster
--engine-version new_version
--allow-major-version-upgrade
--no-apply-immediately

Postgres database upgrade failed (11.6 -> 13.7)

Relevant content