From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: snzhuravlev@gmail.com
Subject: BUG #16738: Migration from 12th to 13th version. pg_upgrade error (relation "pg_catalog.pg_pltemplate")
Date: Sat, 21 Nov 2020 13:09:47 +0000
Message-ID: <16738-ace36adae38f6b10@postgresql.org> (raw)
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";
"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, snzhuravlev@gmail.com
Subject: Re: BUG #16738: Migration from 12th to 13th version. pg_upgrade error (relation "pg_catalog.pg_pltemplate")
In-Reply-To: <16738-ace36adae38f6b10@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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