Am Donnerstag, 28. Januar 2021, 16:56:44 CET schrieben Sie:
> On Thu, Jan 28, 2021 at 10:43:45AM -0500, Tom Lane wrote:
> > Bruce Momjian <bruce@momjian.us> writes:
> > > On Thu, Jan 28, 2021 at 10:34:46AM -0500, Tom Lane wrote:
> > >> PG Bug reporting form <noreply@postgresql.org> writes:
> > >>> pg_restore: Error: could not execute query: ERROR: Language »plperlu«
> > >>> does
> > >>> not exist
> > >>> The statement was: CREATE OR REPLACE PROCEDURAL LANGUAGE "plperlu";
> > >>
> > >> It looks like you neglected to install the plperlu package
> > >> (it's probably named something like postgresql-plperl).
> > >
> > > Yeah, I am confused why this was not reported clearly to the user.
> >
> > It is odd that pg_upgrade's checks didn't catch it earlier. But
> > we can't investigate without more info about exactly what Postgres
> > packages are present on the OP's system.
>
> Yes, usually the error report is very clear, we would need to see
> _exactly_ what they saw.
Hello,
to clearify,
- plperl package is already installed (see below).
- command 'CREATE OR REPLACE PROCEDURAL LANGUAGE "plperlu";' doesn't create a language object, but just an extension object (see below)
Please note the attached upgrade log file from pg_upgrade "pg_upgrade_dump_16401.log".
OS Packages:
postgresql-llvmjit-13-lp152.3.1.noarch
postgresql12-pldebugger-1.0+git13.ddbce7b-lp152.1.4.x86_64
postgresql12-llvmjit-12.5-lp152.34.1.x86_64
postgresql-13-lp152.3.1.noarch
postgresql12-docs-12.5-lp152.34.1.noarch
postgresql12-contrib-12.5-lp152.34.1.x86_64
postgresql13-plperl-13.1-lp152.16.1.x86_64
postgresql12-server-12.5-lp152.34.1.x86_64
postgresql-docs-13-lp152.3.1.noarch
postgresql12-12.5-lp152.34.1.x86_64
postgresql12-pg_qualstats-2.0.2-lp152.2.3.x86_64
postgresql12-ip4r-2.4.1+git1.5f9ce88-lp152.8.2.x86_64
postgresql-server-13-lp152.3.1.noarch
postgresql12-pg_qualstats-llvmjit-2.0.2-lp152.2.3.x86_64
postgresql13-docs-13.1-lp152.16.1.noarch
postgresql13-server-13.1-lp152.16.1.x86_64
postgresql-contrib-13-lp152.3.1.noarch
postgresql12-ip4r-llvmjit-2.4.1+git1.5f9ce88-lp152.8.2.x86_64
postgresql13-13.1-lp152.16.1.x86_64
postgresql13-llvmjit-13.1-lp152.16.1.x86_64
postgresql-plperl-13-lp152.3.1.noarch
postgresql12-pldebugger-llvmjit-1.0+git13.ddbce7b-lp152.1.4.x86_64
postgresql13-contrib-13.1-lp152.16.1.x86_64
Output from failed database upgrade:
botdb=# \dL