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

 · 

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