Postgres Pro
Downloads
Home   >   mailing lists

12 to 13 migration, the privs error with pg_pltemplate - Mailing list pgsql-admin

From Scott Ribe
Subject 12 to 13 migration, the privs error with pg_pltemplate
Date
Msg-id 074FE83A-E924-4787-9E68-27EB9CE142B3@elevated-dev.com
Whole thread Raw
Responses Re: 12 to 13 migration, the privs error with pg_pltemplate  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
So I'm getting the error when migrating about not being able to GRANT SELECT on pg_catalog.pg_pltemplate, as referenced
here:

https://www.postgresql-archive.org/pg-upgrade-issue-upgrading-10-gt-13-td6156401.html

BUT:

- we have never intentionally modified privs on system tables
- I tried REVOKE ALL FROM pg_catalog.pg_pltemplate ... in the source database, still got the same error
- \dp pg_catalog.pg_pltemplate only shows:

postgres=ardDxt/postgres+
=r/postgres

Suggestions?

--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Auto-analyse vs manual analyze
Next
From: Tom Lane
Date:
Subject: Re: 12 to 13 migration, the privs error with pg_pltemplate