Re: BUG #16738: Migration from 12th to 13th version. pg_upgrade error (relation "pg_catalog.pg_pltemplate")

Поиск
Список
Период
Сортировка
От Victor Yegorov
Тема Re: BUG #16738: Migration from 12th to 13th version. pg_upgrade error (relation "pg_catalog.pg_pltemplate")
Дата
Msg-id CAGnEboiMofJ2nkWo=HvdyL7Z0qzgoNFBgXqgYtA6Wb38yZdyaQ@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #16738: Migration from 12th to 13th version. pg_upgrade error (relation "pg_catalog.pg_pltemplate")  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Дерево обсуждения
сб, 21 нояб. 2020 г. в 14:48, PG Bug reporting form <noreply@postgresql.org>:

Error
...
pg_restore: creating ACL "pg_catalog.TABLE "pg_partitioned_table""
pg_restore: creating ACL "pg_catalog.TABLE "pg_pltemplate""
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 12691; 0 0 ACL TABLE "pg_pltemplate" postgres
pg_restore: error: could not execute query: ERROR:  relation
"pg_catalog.pg_pltemplate" does not exist
Command was: GRANT ALL ON TABLE "pg_catalog"."pg_pltemplate" TO
"dhw_admin";

This is not a PostgreSQL issue. You have granted custom permissions to a catalog table.
There is an attempt to transfer your grant, but in 13 there is no more pg_pltemplate catalog, thus the error.

You need to revoke this grant on the 12 database before performing pg_upgrade.
 
--
Victor Yegorov

В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16738: Migration from 12th to 13th version. pg_upgrade error (relation "pg_catalog.pg_pltemplate")
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #16732: pg_dump creates broken backups