Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l5Twh-0000iq-2J for pgsql-bugs@arkaria.postgresql.org; Fri, 29 Jan 2021 13:36:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l5Twf-0003KQ-VP for pgsql-bugs@arkaria.postgresql.org; Fri, 29 Jan 2021 13:36:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l5Twf-0003KH-Ke for pgsql-bugs@lists.postgresql.org; Fri, 29 Jan 2021 13:36:17 +0000 Received: from mout.gmx.net ([212.227.15.15]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l5Twc-0005a7-8h for pgsql-bugs@lists.postgresql.org; Fri, 29 Jan 2021 13:36:16 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1611927370; bh=s6rR9jAjzmMZqJ3/+ZrTOJHfYn8UROY0sc/reXZ6IWo=; h=X-UI-Sender-Class:From:To:Cc:Subject:Date:In-Reply-To:References; b=H9PCEh8grrhzZ3ASiYDYdBSh71Pw9oohV2AelTBuZO8mAl5BedJtkC770dL2Z7Xtw G5ygtw+M92pMS0KdBOSxFExTeQtwsbzuSViBNXWV4tSqRP3ZgG9jdhAYUdG1kAkjua l9DEtbwcty8hTKFg88zzJkvf2QCAfplJ/BsRyGAY= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from wolfclan.ang.de ([87.191.134.178]) by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MMXQ5-1lMrnx1SzP-00JXkK; Fri, 29 Jan 2021 14:36:10 +0100 From: GMX LINREG To: Bruce Momjian , Tom Lane 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> In-Reply-To: <20210128155644.GB14227@momjian.us> References: <16843-174d3e5b66729a60@postgresql.org> <2547214.1611848625@sss.pgh.pa.us> <20210128155644.GB14227@momjian.us> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="nextPart2549123.X9hSmTKtgW" Content-Transfer-Encoding: 7Bit X-Provags-ID: V03:K1:oGdg0i4S4cC8L8EIjsxXe6jhGNPmvJoMIqxb3uQU9csDRZJF5xY s95l16QTbYX+r4a4Go9fr0VwppGSshpwKfGGZMCWYowtieVzxWdK1DLwLKXHzywSfvnbApQ OTpDcJgUpQGloaRMT44nluy2HuDM8BT6Fjafwvt1WkCQt+3aNLlF3mIP/jZcFvUK7q52ZBy FEJXnXspk2fNAKnr9GfPw== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:ZQuHnJ5EI0w=:pZ712LmZggjbQ5ejiGYO5M ynvHZu8o7cmFyF3n2lvuCa/b61EriCf3dlTPxx+5cTXs4pnjuCq7tEpnhBqt0plkPQvDJoJbP t1FLaVKlnDHsc6IP46qZoPiHrAbBXnnlTyJ/VLUZ5Otym0fcfWedz7cGdnbDatjSQU4ON61O3 WSCWeeKX2CFLtG+rm2xSYgKFUkiAICOGHWahr7J/h/EoG5C0/ZmzQib49+JXrRssvjUiftyLB QfQjRH+b0i4Iuar9dzMHw/CHUnV2zyWIN9MRn40P0NjkG+WeEvYbp+kI2kTKy/2OOfSFlakLc BhY9x7IfrtREIxRAuiLs/x/Ecy+MDb0Lr+Mk7e1sWyQ+LOF0q7fUEFth7AaQCgyzqnUAnXEvx YRUunJb7oZUvYcO6PqATdFVRQHavVrdxjBW24sxQglkZs4lcPTEdcvlQ+sd4rgDL/YmtgtrfN suOdWGwgQQZIKsx5aGaviR2r37rxzHZXWrCnHdin+wIqkDS8R59+W4o+xPrX7ZnHrwTPjrXh4 mJ77DTAio9QdPXmN5rB4xaHjtfa5eGQT0uT8+ST/KrrbxLZ+BSCVb+9Vg2RnbOCWsv3qadL7D qF4qI9mXRQHTk8RvpbJ+022gbQtLOvU1iq/l/OiOe0/KD/YllWEQylpLsg+6M76oSh7II6rh6 zgpg9GztJLRj3WletonN9aoiO6jKdfRa1BQKsCmJUactKV3OKDxeHiQXH4JCOyWSfxKwSBZsY WcM+5CBbSfWNTVKnEI/l3ek8envAre6YYRiP8Jz36LFbBTwiCXYzk6tZpjjycOfJnWUctuJxI 5+EM6TALh73kq7iReJKhytAnJ3aQsDz5upgsv0zp8CG2wSIK00Ihpyh0l3kvm0ojNglYFRJ+i IWYQT7z9A1JtNf+IQWmA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --nextPart2549123.X9hSmTKtgW Content-Type: multipart/alternative; boundary="nextPart4716322.0VBMTVartN" Content-Transfer-Encoding: 7Bit This is a multi-part message in MIME format. --nextPart4716322.0VBMTVartN Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" Hello, (third trial) to clearify,=20 =2D plperl package is already installed (see below). =2D command 'CREATE OR REPLACE PROCEDURAL LANGUAGE "plperlu";' doesn't crea= te a=20 language object, but just an extension object (see below) Output from failed database upgrade: botdb=3D# \dL=20 Liste der Sprachen=20 Name | Eigent=FCmer | Vertraut | Beschreibung =20 =2D--------+------------+----------+------------------------------=20 plpgsql | postgres | t | PL/pgSQL procedural language=20 (1 Zeile)=20 botdb=3D# \dx=20 Liste der installierten Erweiterungen=20 Name | Version | Schema | Beschreibung = =20 =2D-------------+---------+------------ +--------------------------------------------------=20 hstore | 1.5 | pg_catalog | data type for storing sets of (key,=20 value) pairs=20 pg_cron | 4.0.4 | public | Cron-like Job Scheduler for PostgreSQ= L=20 pg_http | 1.4.1 | public | A web service for PostgreSQL=20 pg_mqtt | 1.1 | public | A mqtt client daemon for PostgreSQL=20 pg_reporting | 1.1 | public | A reporting extension for PostgreSQL= =20 plperlu | 1.0 | pg_catalog | PL/PerlU untrusted procedural languag= e=20 plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language best regards=20 Thomas Steffen --nextPart4716322.0VBMTVartN Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="iso-8859-1"

Hello, (third trial)


to clearify,

- p= lperl package is already installed (see below).

- c= ommand 'CREATE OR REPLACE PROCEDURAL LANGUAGE "plperlu";' doesn't= create a

lan= guage object, but just an extension object (see below)


Output from failed database upgrade:

bot= db=3D# \dL

&nb= sp;            =          Liste der Sprachen

&nb= sp;Name   | Eigent=FCmer | Vertraut |    &nbs= p;    Beschreibung       =   

---= =2D-----+------------+----------+------------------------------

plp= gsql | postgres   | t        |= PL/pgSQL procedural language

(1 = Zeile)


botdb=3D# \dx

&nb= sp;            =            Liste der inst= allierten Erweiterungen

&nb= sp;   Name     | Version |   Schema=    |          &= nbsp;        Beschreibung  &nb= sp;            =     

---= =2D----------+---------+------------

+--= =2D-----------------------------------------------

hst= ore       | 1.5     | pg_= catalog | data type for storing sets of (key,

val= ue) 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&n= bsp;    | A mqtt client daemon for PostgreSQL

pg_= reporting | 1.1     | public     | = A reporting extension for PostgreSQL

plp= erlu      | 1.0     | pg_catal= og | PL/PerlU untrusted procedural language

plp= gsql      | 1.0     | pg_catal= og | PL/pgSQL procedural language


best regards


Thomas Steffen


--nextPart4716322.0VBMTVartN-- --nextPart2549123.X9hSmTKtgW Content-Disposition: attachment; filename="pg_upgrade_dump_16401.log" Content-Transfer-Encoding: quoted-printable Content-Type: text/x-log; charset="utf-8"; name="pg_upgrade_dump_16401.log" command: "/usr/lib/postgresql13/bin/pg_dump" --host /var/lib/pgsql --port 5= 0432 --username postgres --schema-only --quote-all-identifiers --binary-upg= rade --format=3Dcustom --file=3D"pg_upgrade_dump_16401.custom" 'dbname=3Db= otdb' >> "pg_upgrade_dump_16401.log" 2>&1 command: "/usr/lib/postgresql13/bin/pg_dump" --host /var/lib/pgsql --port 5= 0432 --username postgres --schema-only --quote-all-identifiers --binary-upg= rade --format=3Dcustom --file=3D"pg_upgrade_dump_16401.custom" 'dbname=3Db= otdb' >> "pg_upgrade_dump_16401.log" 2>&1 command: "/usr/lib/postgresql13/bin/pg_restore" --host /var/lib/pgsql --por= t 50432 --username postgres --create --exit-on-error --verbose --dbname tem= plate1 "pg_upgrade_dump_16401.custom" >> "pg_upgrade_dump_16401.log" 2>&1 pg_restore: verbinde mit der Datenbank zur Wiederherstellung pg_restore: erstelle DATABASE =C2=BBbotdb=C2=AB pg_restore: verbinde mit neuer Datenbank =C2=BBbotdb=C2=AB pg_restore: erstelle DATABASE PROPERTIES =C2=BBbotdb=C2=AB pg_restore: verbinde mit neuer Datenbank =C2=BBbotdb=C2=AB pg_restore: erstelle pg_largeobject =C2=BBpg_largeobject=C2=AB pg_restore: erstelle SCHEMA =C2=BBcallbot=C2=AB pg_restore: erstelle SCHEMA =C2=BBcrm_test=C2=AB pg_restore: erstelle SCHEMA =C2=BBfirmenbots=C2=AB pg_restore: erstelle SCHEMA =C2=BBgeo=C2=AB pg_restore: erstelle SCHEMA =C2=BBimmo=C2=AB pg_restore: erstelle SCHEMA =C2=BBlassi=C2=AB pg_restore: erstelle SCHEMA =C2=BBmieten_kataster=C2=AB pg_restore: erstelle SCHEMA =C2=BBmy_cam_bot=C2=AB pg_restore: erstelle EXTENSION =C2=BBpg_cron=C2=AB pg_restore: erstelle COMMENT =C2=BBEXTENSION "pg_cron"=C2=AB pg_restore: erstelle SCHEMA =C2=BBpgcron=C2=AB pg_restore: erstelle COMMENT =C2=BBSCHEMA "pgcron"=C2=AB pg_restore: erstelle EXTENSION =C2=BBhstore=C2=AB pg_restore: erstelle COMMENT =C2=BBEXTENSION "hstore"=C2=AB pg_restore: erstelle EXTENSION =C2=BBpg_http=C2=AB pg_restore: erstelle COMMENT =C2=BBEXTENSION "pg_http"=C2=AB pg_restore: erstelle SCHEMA =C2=BBpghttp=C2=AB pg_restore: erstelle EXTENSION =C2=BBpg_mqtt=C2=AB pg_restore: erstelle COMMENT =C2=BBEXTENSION "pg_mqtt"=C2=AB pg_restore: erstelle SCHEMA =C2=BBpgmqtt=C2=AB pg_restore: erstelle SCHEMA =C2=BBplaner=C2=AB pg_restore: erstelle SCHEMA =C2=BBprivatebots=C2=AB pg_restore: erstelle SCHEMA =C2=BBreplication=C2=AB pg_restore: erstelle EXTENSION =C2=BBpg_reporting=C2=AB pg_restore: erstelle COMMENT =C2=BBEXTENSION "pg_reporting"=C2=AB pg_restore: erstelle SCHEMA =C2=BBreporting=C2=AB pg_restore: erstelle SCHEMA =C2=BBtaskbot=C2=AB pg_restore: erstelle SCHEMA =C2=BBteams=C2=AB pg_restore: erstelle SCHEMA =C2=BBtelegram=C2=AB pg_restore: erstelle SCHEMA =C2=BBwebsites=C2=AB pg_restore: erstelle EXTENSION =C2=BBplperlu=C2=AB pg_restore: erstelle COMMENT =C2=BBEXTENSION "plperlu"=C2=AB pg_restore: erstelle PROCEDURAL LANGUAGE =C2=BBplperlu=C2=AB pg_restore: in Phase PROCESSING TOC: pg_restore: in Inhaltsverzeichniseintrag 2151; 2612 16427 PROCEDURAL LANGUA= GE plperlu postgres pg_restore: Fehler: could not execute query: FEHLER: Sprache =C2=BBplperlu= =C2=AB existiert nicht Die Anweisung war: CREATE OR REPLACE PROCEDURAL LANGUAGE "plperlu"; =2D- For binary upgrade, handle extension membership the hard way ALTER EXTENSION "plperlu" ADD LANGUAGE "plperlu"; --nextPart2549123.X9hSmTKtgW--