pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16738: Migration from 12th to 13th version. pg_upgrade error (relation "pg_catalog.pg_pltemplate")
2+ messages / 2 participants
[nested] [flat]

* BUG #16738: Migration from 12th to 13th version. pg_upgrade error (relation "pg_catalog.pg_pltemplate")
@ 2020-11-21 13:09  PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Bug reporting form @ 2020-11-21 13:09 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: snzhuravlev@gmail.com

The following bug has been logged on the website:

Bug reference:      16738
Logged by:          Sergey Zhuravlev
Email address:      snzhuravlev@gmail.com
PostgreSQL version: 12.5
Operating system:   CentOS Linux release 7.9.2009 (Core)
Description:        

Hello.

Checking
$ /usr/pgsql-13/bin/pg_upgrade --old-datadir=/u01/12/data/
--new-datadir=/u01/13/data/ --old-bindir=/usr/pgsql-12/bin
--new-bindir=/usr/pgsql-13/bin --old-options '-c
config_file=/u01/12/data/postgresql.conf' --new-options '-c
config_file=/u01/13/data/postgresql.conf' --check
Performing Consistency Checks on Old Live Server
------------------------------------------------
Checking cluster versions                                   ok
Checking database user is the install user                  ok
Checking database connection settings                       ok
Checking for prepared transactions                          ok
Checking for reg* data types in user tables                 ok
Checking for contrib/isn with bigint-passing mismatch       ok
Checking for presence of required libraries                 ok
Checking database user is the install user                  ok
Checking for prepared transactions                          ok
Checking for new cluster tablespace directories             ok

*Clusters are compatible*
---------------------
Link
$ /usr/pgsql-13/bin/pg_upgrade --old-datadir=/u01/12/data/
--new-datadir=/u01/13/data/ --old-bindir=/usr/pgsql-12/bin
--new-bindir=/usr/pgsql-13/bin --old-options '-c
config_file=/u01/12/data/postgresql.conf' --new-options '-c
config_file=/u01/13/data/postgresql.conf' --link
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";
"



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BUG #16738: Migration from 12th to 13th version. pg_upgrade error (relation "pg_catalog.pg_pltemplate")
@ 2020-11-21 13:59  Victor Yegorov <vyegorov@gmail.com>
  parent: PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Victor Yegorov @ 2020-11-21 13:59 UTC (permalink / raw)
  To: snzhuravlev@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

сб, 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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2020-11-21 13:59 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-11-21 13:09 BUG #16738: Migration from 12th to 13th version. pg_upgrade error (relation "pg_catalog.pg_pltemplate") PG Bug reporting form <noreply@postgresql.org>
2020-11-21 13:59 ` Victor Yegorov <vyegorov@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox