Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: 12 to 13 migration, the privs error with pg_pltemplate
Date
Msg-id 3264512.1607456932@sss.pgh.pa.us
Whole thread Raw
In response to 12 to 13 migration, the privs error with pg_pltemplate  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: 12 to 13 migration, the privs error with pg_pltemplate  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view 
Scott Ribe <scott_ribe@elevated-dev.com> writes:
> So I'm getting the error when migrating about not being able to GRANT SELECT on pg_catalog.pg_pltemplate, as
referencedhere: 
> https://www.postgresql-archive.org/pg-upgrade-issue-upgrading-10-gt-13-td6156401.html
> Suggestions?

There is probably an entry in pg_default_acl that is causing this.
You could likely just manually remove that.

            regards, tom lane

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: 12 to 13 migration, the privs error with pg_pltemplate
Next
From: Ron
Date:
Subject: LDAP and roles