| From: | Victor Yegorov <vyegorov(at)gmail(dot)com> |
|---|---|
| To: | snzhuravlev(at)gmail(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #16738: Migration from 12th to 13th version. pg_upgrade error (relation "pg_catalog.pg_pltemplate") |
| Date: | 2020-11-21 13:59:24 |
| Message-ID: | CAGnEboiMofJ2nkWo=HvdyL7Z0qzgoNFBgXqgYtA6Wb38yZdyaQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
сб, 21 нояб. 2020 г. в 14:48, PG Bug reporting form <noreply(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2020-11-21 17:06:38 | Re: BUG #16732: pg_dump creates broken backups |
| Previous Message | PG Bug reporting form | 2020-11-21 13:09:47 | BUG #16738: Migration from 12th to 13th version. pg_upgrade error (relation "pg_catalog.pg_pltemplate") |