pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feed From: GMX LINREG <linreg@gmx.net>
To: Bruce Momjian <bruce@momjian.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed
Date: Fri, 29 Jan 2021 14:36:09 +0100
Message-ID: <4340453.cEBGB3zze1@wolfclan.ang.de> (raw )
In-Reply-To: <20210128155644.GB14227@momjian.us >
References: <16843-174d3e5b66729a60@postgresql.org >
<2547214.1611848625@sss.pgh.pa.us >
<20210128155644.GB14227@momjian.us >
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
Attachments:
pg_upgrade_dump_16401.log (text/x-log, 2.9K) download
command: "/usr/lib/postgresql13/bin/pg_dump" --host /var/lib/pgsql --port 50432 --username postgres --schema-only --quote-all-identifiers --binary-upgrade --format=custom --file="pg_upgrade_dump_16401.custom" 'dbname=botdb' >> "pg_upgrade_dump_16401.log" 2>&1
command: "/usr/lib/postgresql13/bin/pg_dump" --host /var/lib/pgsql --port 50432 --username postgres --schema-only --quote-all-identifiers --binary-upgrade --format=custom --file="pg_upgrade_dump_16401.custom" 'dbname=botdb' >> "pg_upgrade_dump_16401.log" 2>&1
command: "/usr/lib/postgresql13/bin/pg_restore" --host /var/lib/pgsql --port 50432 --username postgres --create --exit-on-error --verbose --dbname template1 "pg_upgrade_dump_16401.custom" >> "pg_upgrade_dump_16401.log" 2>&1
pg_restore: verbinde mit der Datenbank zur Wiederherstellung
pg_restore: erstelle DATABASE »botdb«
pg_restore: verbinde mit neuer Datenbank »botdb«
pg_restore: erstelle DATABASE PROPERTIES »botdb«
pg_restore: verbinde mit neuer Datenbank »botdb«
pg_restore: erstelle pg_largeobject »pg_largeobject«
pg_restore: erstelle SCHEMA »callbot«
pg_restore: erstelle SCHEMA »crm_test«
pg_restore: erstelle SCHEMA »firmenbots«
pg_restore: erstelle SCHEMA »geo«
pg_restore: erstelle SCHEMA »immo«
pg_restore: erstelle SCHEMA »lassi«
pg_restore: erstelle SCHEMA »mieten_kataster«
pg_restore: erstelle SCHEMA »my_cam_bot«
pg_restore: erstelle EXTENSION »pg_cron«
pg_restore: erstelle COMMENT »EXTENSION "pg_cron"«
pg_restore: erstelle SCHEMA »pgcron«
pg_restore: erstelle COMMENT »SCHEMA "pgcron"«
pg_restore: erstelle EXTENSION »hstore«
pg_restore: erstelle COMMENT »EXTENSION "hstore"«
pg_restore: erstelle EXTENSION »pg_http«
pg_restore: erstelle COMMENT »EXTENSION "pg_http"«
pg_restore: erstelle SCHEMA »pghttp«
pg_restore: erstelle EXTENSION »pg_mqtt«
pg_restore: erstelle COMMENT »EXTENSION "pg_mqtt"«
pg_restore: erstelle SCHEMA »pgmqtt«
pg_restore: erstelle SCHEMA »planer«
pg_restore: erstelle SCHEMA »privatebots«
pg_restore: erstelle SCHEMA »replication«
pg_restore: erstelle EXTENSION »pg_reporting«
pg_restore: erstelle COMMENT »EXTENSION "pg_reporting"«
pg_restore: erstelle SCHEMA »reporting«
pg_restore: erstelle SCHEMA »taskbot«
pg_restore: erstelle SCHEMA »teams«
pg_restore: erstelle SCHEMA »telegram«
pg_restore: erstelle SCHEMA »websites«
pg_restore: erstelle EXTENSION »plperlu«
pg_restore: erstelle COMMENT »EXTENSION "plperlu"«
pg_restore: erstelle PROCEDURAL LANGUAGE »plperlu«
pg_restore: in Phase PROCESSING TOC:
pg_restore: in Inhaltsverzeichniseintrag 2151; 2612 16427 PROCEDURAL LANGUAGE plperlu postgres
pg_restore: Fehler: could not execute query: FEHLER: Sprache »plperlu« existiert nicht
Die Anweisung war: CREATE OR REPLACE PROCEDURAL LANGUAGE "plperlu";
-- For binary upgrade, handle extension membership the hard way
ALTER EXTENSION "plperlu" ADD LANGUAGE "plperlu";
view thread (14+ messages) latest in thread
Message-ID: <4340453.cEBGB3zze1@wolfclan.ang.de>
Permalink: ../4340453.cEBGB3zze1@wolfclan.ang.de/
Also on: postgresql.org/message-id/4340453.cEBGB3zze1@wolfclan.ang.de
copy link · copy postgr.es
reply 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: linreg@gmx.net, bruce@momjian.us, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed
In-Reply-To: <4340453.cEBGB3zze1@wolfclan.ang.de>
* 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