Postgres database upgrade failed (11.6 -> 13.7)

0

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?

1개 답변
0

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

profile pictureAWS
지원 엔지니어
Brandon
답변함 일 년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠