Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed

From: GMX LINREG <linreg(at)gmx(dot)net>
To: Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed
Date: 2021-01-29 13:36:09
Message-ID: 4340453.cEBGB3zze1@wolfclan.ang.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello, (third trial)

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)

Output from failed database upgrade:
botdb=# \dL
Liste der Sprachen
Name | Eigentümer | Vertraut | Beschreibung
---------+------------+----------+------------------------------
plpgsql | postgres | t | PL/pgSQL procedural language
(1 Zeile)

botdb=# \dx
Liste der installierten Erweiterungen
Name | Version | Schema | Beschreibung
--------------+---------+------------
+--------------------------------------------------
hstore | 1.5 | pg_catalog | data type for storing sets of (key,
value) pairs
pg_cron | 4.0.4 | public | Cron-like Job Scheduler for PostgreSQL
pg_http | 1.4.1 | public | A web service for PostgreSQL
pg_mqtt | 1.1 | public | A mqtt client daemon for PostgreSQL
pg_reporting | 1.1 | public | A reporting extension for PostgreSQL
plperlu | 1.0 | pg_catalog | PL/PerlU untrusted procedural language
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language

best regards

Thomas Steffen

Attachment Content-Type Size
pg_upgrade_dump_16401.log text/x-log 2.9 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2021-01-29 15:04:54 Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed
Previous Message linreg 2021-01-29 13:29:09 Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed