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 1l5Tpb-0000F1-9j for pgsql-bugs@arkaria.postgresql.org; Fri, 29 Jan 2021 13:28:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l5TpZ-0008Gi-4v for pgsql-bugs@arkaria.postgresql.org; Fri, 29 Jan 2021 13:28:57 +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 1l5TkS-0007lE-Rh for pgsql-bugs@lists.postgresql.org; Fri, 29 Jan 2021 13:23:41 +0000 Received: from mout.gmx.net ([212.227.17.22]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l5TkP-0005UZ-Ow for pgsql-bugs@lists.postgresql.org; Fri, 29 Jan 2021 13:23:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1611926613; bh=YrBXjXm4BzkLcBy1NxIPpcl13+gDbtBVO9vORKe6408=; h=X-UI-Sender-Class:From:To:Cc:Subject:Date:In-Reply-To:References; b=eCSGuWlH74hKJCUqU40vzKdekARqWP3tzzGnrMTGWOV+K9IgXNeyFsnIWH1z1SuVj IlTFC9sNqzYFHKwfqAH37cEWYp3JfWakAG3dsyhf4sQM9blxywPib4hlBB2otCkrei s2dETGwB1CRWrPYkaY0o59bPpVejfG+dVbdnw+pQ= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from wolfclan.ang.de ([87.191.134.178]) by mail.gmx.net (mrgmx105 [212.227.17.168]) with ESMTPSA (Nemesis) id 1MdNcG-1leoZ31qa0-00ZNpv; Fri, 29 Jan 2021 14:23:33 +0100 From: GMX Steffen 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:23:31 +0100 Message-ID: <7226587.EvYhyI6sBW@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="nextPart3374733.iIbC2pHGDl" Content-Transfer-Encoding: 7Bit X-Provags-ID: V03:K1:ogdHgDp5wdLokD5wY+vc+6OlAPl2f4abPfL1jEAmDt/raZhnqao UwMpBGShximelIbtFe0kVxtYxKhNr84Kd4DKjeiciV/+v0m1dewQUORBgFiNGdnFMlXLkYo W2+NK7xQjFg9Q4gDMeIL4axwx5j7Abv9o1U1uqh63LIxeSmYRuZa9YbEfTpYMaJZ1cAuQ96 Rx7JWTa1FX3nXYopOz1qA== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:S0/cck28PoM=:brlXgJnYYqEYKKMV5EyHrs ecJLSXKzSWgXOD6QJsOwlSz/gmkWn3zidEX3fTo6pp1wJLojt3avGQJQ2VHn19kIOR5LbEE1K Gg8kuKsOcd58ATuk9Jl+3dwa98lz1iiFg4zF/6WPGspEMviDmBR+RcX98XJ/LOHUjkPt2nf+O AM1KNrNpHMcLsonWE6cFaG5bY30MFu29QCaYSLFsQ3wXhVHH0OuyQAbsH6pNxQS9+r+dSK19K QmbcblUGnYGq5La9T71mDZyfVBYohTTKYkrgcBAuHnAgaOPc90XdZhVf5wg0/3fFSEqImRZbg 8AylwHYIPG4MbrHUK3iGN0MDUyJ9o3QM+7ix7hEIOV3TDypxVLrMgViINGq/Mly/sJ51iZbBM qzATR5LTM+D2oBYISdWm6lsCSFO9BSKK2RiYdK/Z2kROplg3W4+4o7B0tVF2HB6aeiWhMozhM IfavJw+RCgo7vesdcf//ueIz/C+5X3c2gpGddWTiVj9C+p28JEndh8VHYreFMU/ftwRBUuBSX aHBJIxywnwmGEQTLFgsfxydL5mm02s/sRRnfALWuMz5rFLyxscYXgLsHtZzC5k4fP3sxVKHvd UP4MwENJ9PS/YZVplcikHE+R9cNjAihCT88kLjS5uasKc+5lvoW+U30gpIkdaqrOxHjjkkLVM aoYUAz9IDCScXvGQds2zkYpoAUsKdGyd7skuQZTIoBGBGHv1NcmV+weRVplfHWbss//5aNoa6 C57riA2EAyoGJWgy33oSNfAcE+7EC3LSKdNMvjvaYe7h+0Ekb+dJ6BS+hATWlipKOUHAxIxOx SxdjhVEGKSA1ii1zNcuC484mD08l8oeCvEi4to/x3fP1NFRe/JqhFNbWr202qu24TlJJ0Jx/n 75ZsbYsBbLAmVD8BhW6g== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --nextPart3374733.iIbC2pHGDl Content-Type: multipart/alternative; boundary="nextPart3604603.kQq0lBPeGt" Content-Transfer-Encoding: 7Bit This is a multi-part message in MIME format. --nextPart3604603.kQq0lBPeGt Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" 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 writes: > > > On Thu, Jan 28, 2021 at 10:34:46AM -0500, Tom Lane wrote: > > >> PG Bug reporting form writes: > > >>> pg_restore: Error: could not execute query: ERROR: Language =BBplp= erlu=AB > > >>> does > > >>> not exist > > >>> The statement was: CREATE OR REPLACE PROCEDURAL LANGUAGE "plperlu"; > > >>=20 > > >> It looks like you neglected to install the plperlu package > > >> (it's probably named something like postgresql-plperl). > > >=20 > > > Yeah, I am confused why this was not reported clearly to the user. > >=20 > > 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. >=20 > Yes, usually the error report is very clear, we would need to see > _exactly_ what they saw. Hello, 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) Please note the attached upgrade log file from pg_upgrade "pg_upgrade_dump_= 16401.log". OS Packages: *postgresql*-llvmjit-13-lp152.3.1.noarch=20 *postgresql*12-pldebugger-1.0+git13.ddbce7b-lp152.1.4.x86_64=20 *postgresql*12-llvmjit-12.5-lp152.34.1.x86_64=20 *postgresql*-13-lp152.3.1.noarch=20 *postgresql*12-docs-12.5-lp152.34.1.noarch=20 *postgresql*12-contrib-12.5-lp152.34.1.x86_64=20 *postgresql*13-plperl-13.1-lp152.16.1.x86_64=20 *postgresql*12-server-12.5-lp152.34.1.x86_64=20 *postgresql*-docs-13-lp152.3.1.noarch=20 *postgresql*12-12.5-lp152.34.1.x86_64=20 *postgresql*12-pg_qualstats-2.0.2-lp152.2.3.x86_64=20 *postgresql*12-ip4r-2.4.1+git1.5f9ce88-lp152.8.2.x86_64=20 *postgresql*-server-13-lp152.3.1.noarch=20 *postgresql*12-pg_qualstats-llvmjit-2.0.2-lp152.2.3.x86_64=20 *postgresql*13-docs-13.1-lp152.16.1.noarch=20 *postgresql*13-server-13.1-lp152.16.1.x86_64=20 *postgresql*-contrib-13-lp152.3.1.noarch=20 *postgresql*12-ip4r-llvmjit-2.4.1+git1.5f9ce88-lp152.8.2.x86_64=20 *postgresql*13-13.1-lp152.16.1.x86_64=20 *postgresql*13-llvmjit-13.1-lp152.16.1.x86_64=20 *postgresql*-plperl-13-lp152.3.1.noarch=20 *postgresql*12-pldebugger-llvmjit-1.0+git13.ddbce7b-lp152.1.4.x86_64=20 *postgresql*13-contrib-13.1-lp152.16.1.x86_64 Output from failed database upgrade: botdb=3D# \dL=20 --nextPart3604603.kQq0lBPeGt Content-Transfer-Encoding: base64 Content-Type: text/html; charset="iso-8859-1" PGh0bWw+CjxoZWFkPgo8bWV0YSBodHRwLWVxdWl2PSJjb250ZW50LXR5cGUiIGNvbnRlbnQ9InRl eHQvaHRtbDsgY2hhcnNldD1VVEYtOCI+CjwvaGVhZD4KPGJvZHk+PHAgc3R5bGU9Im1hcmdpbi10 b3A6MDttYXJnaW4tYm90dG9tOjA7bWFyZ2luLWxlZnQ6MDttYXJnaW4tcmlnaHQ6MDsiPkFtIERv bm5lcnN0YWcsIDI4LiBKYW51YXIgMjAyMSwgMTY6NTY6NDQgQ0VUIHNjaHJpZWJlbiBTaWU6PC9w Pgo8cCBzdHlsZT0ibWFyZ2luLXRvcDowO21hcmdpbi1ib3R0b206MDttYXJnaW4tbGVmdDowO21h cmdpbi1yaWdodDowOyI+Jmd0OyBPbiBUaHUsIEphbiAyOCwgMjAyMSBhdCAxMDo0Mzo0NUFNIC0w NTAwLCBUb20gTGFuZSB3cm90ZTo8L3A+CjxwIHN0eWxlPSJtYXJnaW4tdG9wOjA7bWFyZ2luLWJv dHRvbTowO21hcmdpbi1sZWZ0OjA7bWFyZ2luLXJpZ2h0OjA7Ij4mZ3Q7ICZndDsgQnJ1Y2UgTW9t amlhbiAmbHQ7YnJ1Y2VAbW9tamlhbi51cyZndDsgd3JpdGVzOjwvcD4KPHAgc3R5bGU9Im1hcmdp bi10b3A6MDttYXJnaW4tYm90dG9tOjA7bWFyZ2luLWxlZnQ6MDttYXJnaW4tcmlnaHQ6MDsiPiZn dDsgJmd0OyAmZ3Q7IE9uIFRodSwgSmFuIDI4LCAyMDIxIGF0IDEwOjM0OjQ2QU0gLTA1MDAsIFRv bSBMYW5lIHdyb3RlOjwvcD4KPHAgc3R5bGU9Im1hcmdpbi10b3A6MDttYXJnaW4tYm90dG9tOjA7 bWFyZ2luLWxlZnQ6MDttYXJnaW4tcmlnaHQ6MDsiPiZndDsgJmd0OyAmZ3Q7Jmd0OyBQRyBCdWcg cmVwb3J0aW5nIGZvcm0gJmx0O25vcmVwbHlAcG9zdGdyZXNxbC5vcmcmZ3Q7IHdyaXRlczo8L3A+ CjxwIHN0eWxlPSJtYXJnaW4tdG9wOjA7bWFyZ2luLWJvdHRvbTowO21hcmdpbi1sZWZ0OjA7bWFy Z2luLXJpZ2h0OjA7Ij4mZ3Q7ICZndDsgJmd0OyZndDsmZ3Q7IHBnX3Jlc3RvcmU6IEVycm9yOiBj b3VsZCBub3QgZXhlY3V0ZSBxdWVyeTogRVJST1I6Jm5ic3A7IExhbmd1YWdlILtwbHBlcmx1qzwv cD4KPHAgc3R5bGU9Im1hcmdpbi10b3A6MDttYXJnaW4tYm90dG9tOjA7bWFyZ2luLWxlZnQ6MDtt YXJnaW4tcmlnaHQ6MDsiPiZndDsgJmd0OyAmZ3Q7Jmd0OyZndDsgZG9lczwvcD4KPHAgc3R5bGU9 Im1hcmdpbi10b3A6MDttYXJnaW4tYm90dG9tOjA7bWFyZ2luLWxlZnQ6MDttYXJnaW4tcmlnaHQ6 MDsiPiZndDsgJmd0OyAmZ3Q7Jmd0OyZndDsgbm90IGV4aXN0PC9wPgo8cCBzdHlsZT0ibWFyZ2lu LXRvcDowO21hcmdpbi1ib3R0b206MDttYXJnaW4tbGVmdDowO21hcmdpbi1yaWdodDowOyI+Jmd0 OyAmZ3Q7ICZndDsmZ3Q7Jmd0OyBUaGUgc3RhdGVtZW50IHdhczogQ1JFQVRFIE9SIFJFUExBQ0Ug UFJPQ0VEVVJBTCBMQU5HVUFHRSAmcXVvdDtwbHBlcmx1JnF1b3Q7OzwvcD4KPHAgc3R5bGU9Im1h cmdpbi10b3A6MDttYXJnaW4tYm90dG9tOjA7bWFyZ2luLWxlZnQ6MDttYXJnaW4tcmlnaHQ6MDsi PiZndDsgJmd0OyAmZ3Q7Jmd0OyA8L3A+CjxwIHN0eWxlPSJtYXJnaW4tdG9wOjA7bWFyZ2luLWJv dHRvbTowO21hcmdpbi1sZWZ0OjA7bWFyZ2luLXJpZ2h0OjA7Ij4mZ3Q7ICZndDsgJmd0OyZndDsg SXQgbG9va3MgbGlrZSB5b3UgbmVnbGVjdGVkIHRvIGluc3RhbGwgdGhlIHBscGVybHUgcGFja2Fn ZTwvcD4KPHAgc3R5bGU9Im1hcmdpbi10b3A6MDttYXJnaW4tYm90dG9tOjA7bWFyZ2luLWxlZnQ6 MDttYXJnaW4tcmlnaHQ6MDsiPiZndDsgJmd0OyAmZ3Q7Jmd0OyAoaXQncyBwcm9iYWJseSBuYW1l ZCBzb21ldGhpbmcgbGlrZSBwb3N0Z3Jlc3FsLXBscGVybCkuPC9wPgo8cCBzdHlsZT0ibWFyZ2lu LXRvcDowO21hcmdpbi1ib3R0b206MDttYXJnaW4tbGVmdDowO21hcmdpbi1yaWdodDowOyI+Jmd0 OyAmZ3Q7ICZndDsgPC9wPgo8cCBzdHlsZT0ibWFyZ2luLXRvcDowO21hcmdpbi1ib3R0b206MDtt YXJnaW4tbGVmdDowO21hcmdpbi1yaWdodDowOyI+Jmd0OyAmZ3Q7ICZndDsgWWVhaCwgSSBhbSBj b25mdXNlZCB3aHkgdGhpcyB3YXMgbm90IHJlcG9ydGVkIGNsZWFybHkgdG8gdGhlIHVzZXIuPC9w Pgo8cCBzdHlsZT0ibWFyZ2luLXRvcDowO21hcmdpbi1ib3R0b206MDttYXJnaW4tbGVmdDowO21h cmdpbi1yaWdodDowOyI+Jmd0OyAmZ3Q7IDwvcD4KPHAgc3R5bGU9Im1hcmdpbi10b3A6MDttYXJn aW4tYm90dG9tOjA7bWFyZ2luLWxlZnQ6MDttYXJnaW4tcmlnaHQ6MDsiPiZndDsgJmd0OyBJdCBp cyBvZGQgdGhhdCBwZ191cGdyYWRlJ3MgY2hlY2tzIGRpZG4ndCBjYXRjaCBpdCBlYXJsaWVyLiZu YnNwOyBCdXQ8L3A+CjxwIHN0eWxlPSJtYXJnaW4tdG9wOjA7bWFyZ2luLWJvdHRvbTowO21hcmdp bi1sZWZ0OjA7bWFyZ2luLXJpZ2h0OjA7Ij4mZ3Q7ICZndDsgd2UgY2FuJ3QgaW52ZXN0aWdhdGUg d2l0aG91dCBtb3JlIGluZm8gYWJvdXQgZXhhY3RseSB3aGF0IFBvc3RncmVzPC9wPgo8cCBzdHls ZT0ibWFyZ2luLXRvcDowO21hcmdpbi1ib3R0b206MDttYXJnaW4tbGVmdDowO21hcmdpbi1yaWdo dDowOyI+Jmd0OyAmZ3Q7IHBhY2thZ2VzIGFyZSBwcmVzZW50IG9uIHRoZSBPUCdzIHN5c3RlbS48 L3A+CjxwIHN0eWxlPSJtYXJnaW4tdG9wOjA7bWFyZ2luLWJvdHRvbTowO21hcmdpbi1sZWZ0OjA7 bWFyZ2luLXJpZ2h0OjA7Ij4mZ3Q7IDwvcD4KPHAgc3R5bGU9Im1hcmdpbi10b3A6MDttYXJnaW4t Ym90dG9tOjA7bWFyZ2luLWxlZnQ6MDttYXJnaW4tcmlnaHQ6MDsiPiZndDsgWWVzLCB1c3VhbGx5 IHRoZSBlcnJvciByZXBvcnQgaXMgdmVyeSBjbGVhciwgd2Ugd291bGQgbmVlZCB0byBzZWU8L3A+ CjxwIHN0eWxlPSJtYXJnaW4tdG9wOjA7bWFyZ2luLWJvdHRvbTowO21hcmdpbi1sZWZ0OjA7bWFy Z2luLXJpZ2h0OjA7Ij4mZ3Q7IF9leGFjdGx5XyB3aGF0IHRoZXkgc2F3LjwvcD4KPGJyIC8+PHAg c3R5bGU9Im1hcmdpbi10b3A6MDttYXJnaW4tYm90dG9tOjA7bWFyZ2luLWxlZnQ6MDttYXJnaW4t cmlnaHQ6MDsiPkhlbGxvLDwvcD4KPGJyIC8+PHAgc3R5bGU9Im1hcmdpbi10b3A6MDttYXJnaW4t Ym90dG9tOjA7bWFyZ2luLWxlZnQ6MDttYXJnaW4tcmlnaHQ6MDsiPnRvIGNsZWFyaWZ5LCA8L3A+ CjxwIHN0eWxlPSJtYXJnaW4tdG9wOjA7bWFyZ2luLWJvdHRvbTowO21hcmdpbi1sZWZ0OjA7bWFy Z2luLXJpZ2h0OjA7Ij4tIHBscGVybCBwYWNrYWdlIGlzIGFscmVhZHkgaW5zdGFsbGVkIChzZWUg YmVsb3cpLjwvcD4KPHAgc3R5bGU9Im1hcmdpbi10b3A6MDttYXJnaW4tYm90dG9tOjA7bWFyZ2lu LWxlZnQ6MDttYXJnaW4tcmlnaHQ6MDsiPi0gY29tbWFuZCAnQ1JFQVRFIE9SIFJFUExBQ0UgUFJP Q0VEVVJBTCBMQU5HVUFHRSAmcXVvdDtwbHBlcmx1JnF1b3Q7OycgZG9lc24ndCBjcmVhdGUgYSBs YW5ndWFnZSBvYmplY3QsIGJ1dCBqdXN0IGFuIGV4dGVuc2lvbiBvYmplY3QgKHNlZSBiZWxvdyk8 L3A+CjxiciAvPjxwIHN0eWxlPSJtYXJnaW4tdG9wOjA7bWFyZ2luLWJvdHRvbTowO21hcmdpbi1s ZWZ0OjA7bWFyZ2luLXJpZ2h0OjA7Ij5QbGVhc2Ugbm90ZSB0aGUgYXR0YWNoZWQgdXBncmFkZSBs b2cgZmlsZSBmcm9tIHBnX3VwZ3JhZGUgJnF1b3Q7cGdfdXBncmFkZV9kdW1wXzE2NDAxLmxvZyZx dW90Oy48L3A+CjxiciAvPjxwIHN0eWxlPSJtYXJnaW4tdG9wOjA7bWFyZ2luLWJvdHRvbTowO21h cmdpbi1sZWZ0OjA7bWFyZ2luLXJpZ2h0OjA7Ij5PUyBQYWNrYWdlczo8L3A+CjxwIHN0eWxlPSJt YXJnaW4tdG9wOjA7bWFyZ2luLWJvdHRvbTowO21hcmdpbi1sZWZ0OjA7bWFyZ2luLXJpZ2h0OjA7 Ij48c3BhbiBzdHlsZT0iYmFja2dyb3VuZC1jb2xvcjojZmZmZmZmOyI+PHNwYW4gc3R5bGU9ImZv bnQtZmFtaWx5Om1vbm9zcGFjZTsiPjxzdHJvbmc+PHNwYW4gc3R5bGU9ImNvbG9yOiNmZjU0NTQ7 Ij5wb3N0Z3Jlc3FsPC9zcGFuPjwvc3Ryb25nPjxzcGFuIHN0eWxlPSJjb2xvcjojMDAwMDAwOyI+ LWxsdm1qaXQtMTMtbHAxNTIuMy4xLm5vYXJjaCA8L3NwYW4+PC9zcGFuPjwvc3Bhbj48cD4mbmJz cDs8c3Ryb25nPjxzcGFuIHN0eWxlPSJjb2xvcjojZmY1NDU0OyI+cG9zdGdyZXNxbDwvc3Bhbj48 L3N0cm9uZz48c3BhbiBzdHlsZT0iY29sb3I6IzAwMDAwMDsiPjEyLXBsZGVidWdnZXItMS4wK2dp dDEzLmRkYmNlN2ItbHAxNTIuMS40Lng4Nl82NCA8L3NwYW4+PHA+Jm5ic3A7PHN0cm9uZz48c3Bh biBzdHlsZT0iY29sb3I6I2ZmNTQ1NDsiPnBvc3RncmVzcWw8L3NwYW4+PC9zdHJvbmc+PHNwYW4g c3R5bGU9ImNvbG9yOiMwMDAwMDA7Ij4xMi1sbHZtaml0LTEyLjUtbHAxNTIuMzQuMS54ODZfNjQg PC9zcGFuPjxwPiZuYnNwOzxzdHJvbmc+PHNwYW4gc3R5bGU9ImNvbG9yOiNmZjU0NTQ7Ij5wb3N0 Z3Jlc3FsPC9zcGFuPjwvc3Ryb25nPjxzcGFuIHN0eWxlPSJjb2xvcjojMDAwMDAwOyI+LTEzLWxw MTUyLjMuMS5ub2FyY2ggPC9zcGFuPjxwPiZuYnNwOzxzdHJvbmc+PHNwYW4gc3R5bGU9ImNvbG9y OiNmZjU0NTQ7Ij5wb3N0Z3Jlc3FsPC9zcGFuPjwvc3Ryb25nPjxzcGFuIHN0eWxlPSJjb2xvcjoj MDAwMDAwOyI+MTItZG9jcy0xMi41LWxwMTUyLjM0LjEubm9hcmNoIDwvc3Bhbj48cD4mbmJzcDs8 c3Ryb25nPjxzcGFuIHN0eWxlPSJjb2xvcjojZmY1NDU0OyI+cG9zdGdyZXNxbDwvc3Bhbj48L3N0 cm9uZz48c3BhbiBzdHlsZT0iY29sb3I6IzAwMDAwMDsiPjEyLWNvbnRyaWItMTIuNS1scDE1Mi4z NC4xLng4Nl82NCA8L3NwYW4+PHA+Jm5ic3A7PHN0cm9uZz48c3BhbiBzdHlsZT0iY29sb3I6I2Zm NTQ1NDsiPnBvc3RncmVzcWw8L3NwYW4+PC9zdHJvbmc+PHNwYW4gc3R5bGU9ImNvbG9yOiMwMDAw MDA7Ij4xMy1wbHBlcmwtMTMuMS1scDE1Mi4xNi4xLng4Nl82NCA8L3NwYW4+PHA+Jm5ic3A7PHN0 cm9uZz48c3BhbiBzdHlsZT0iY29sb3I6I2ZmNTQ1NDsiPnBvc3RncmVzcWw8L3NwYW4+PC9zdHJv bmc+PHNwYW4gc3R5bGU9ImNvbG9yOiMwMDAwMDA7Ij4xMi1zZXJ2ZXItMTIuNS1scDE1Mi4zNC4x Lng4Nl82NCA8L3NwYW4+PHA+Jm5ic3A7PHN0cm9uZz48c3BhbiBzdHlsZT0iY29sb3I6I2ZmNTQ1 NDsiPnBvc3RncmVzcWw8L3NwYW4+PC9zdHJvbmc+PHNwYW4gc3R5bGU9ImNvbG9yOiMwMDAwMDA7 Ij4tZG9jcy0xMy1scDE1Mi4zLjEubm9hcmNoIDwvc3Bhbj48cD4mbmJzcDs8c3Ryb25nPjxzcGFu IHN0eWxlPSJjb2xvcjojZmY1NDU0OyI+cG9zdGdyZXNxbDwvc3Bhbj48L3N0cm9uZz48c3BhbiBz dHlsZT0iY29sb3I6IzAwMDAwMDsiPjEyLTEyLjUtbHAxNTIuMzQuMS54ODZfNjQgPC9zcGFuPjxw PiZuYnNwOzxzdHJvbmc+PHNwYW4gc3R5bGU9ImNvbG9yOiNmZjU0NTQ7Ij5wb3N0Z3Jlc3FsPC9z cGFuPjwvc3Ryb25nPjxzcGFuIHN0eWxlPSJjb2xvcjojMDAwMDAwOyI+MTItcGdfcXVhbHN0YXRz LTIuMC4yLWxwMTUyLjIuMy54ODZfNjQgPC9zcGFuPjxwPiZuYnNwOzxzdHJvbmc+PHNwYW4gc3R5 bGU9ImNvbG9yOiNmZjU0NTQ7Ij5wb3N0Z3Jlc3FsPC9zcGFuPjwvc3Ryb25nPjxzcGFuIHN0eWxl PSJjb2xvcjojMDAwMDAwOyI+MTItaXA0ci0yLjQuMStnaXQxLjVmOWNlODgtbHAxNTIuOC4yLng4 Nl82NCA8L3NwYW4+PHA+Jm5ic3A7PHN0cm9uZz48c3BhbiBzdHlsZT0iY29sb3I6I2ZmNTQ1NDsi PnBvc3RncmVzcWw8L3NwYW4+PC9zdHJvbmc+PHNwYW4gc3R5bGU9ImNvbG9yOiMwMDAwMDA7Ij4t c2VydmVyLTEzLWxwMTUyLjMuMS5ub2FyY2ggPC9zcGFuPjxwPiZuYnNwOzxzdHJvbmc+PHNwYW4g c3R5bGU9ImNvbG9yOiNmZjU0NTQ7Ij5wb3N0Z3Jlc3FsPC9zcGFuPjwvc3Ryb25nPjxzcGFuIHN0 eWxlPSJjb2xvcjojMDAwMDAwOyI+MTItcGdfcXVhbHN0YXRzLWxsdm1qaXQtMi4wLjItbHAxNTIu Mi4zLng4Nl82NCA8L3NwYW4+PHA+Jm5ic3A7PHN0cm9uZz48c3BhbiBzdHlsZT0iY29sb3I6I2Zm NTQ1NDsiPnBvc3RncmVzcWw8L3NwYW4+PC9zdHJvbmc+PHNwYW4gc3R5bGU9ImNvbG9yOiMwMDAw MDA7Ij4xMy1kb2NzLTEzLjEtbHAxNTIuMTYuMS5ub2FyY2ggPC9zcGFuPjxwPiZuYnNwOzxzdHJv bmc+PHNwYW4gc3R5bGU9ImNvbG9yOiNmZjU0NTQ7Ij5wb3N0Z3Jlc3FsPC9zcGFuPjwvc3Ryb25n PjxzcGFuIHN0eWxlPSJjb2xvcjojMDAwMDAwOyI+MTMtc2VydmVyLTEzLjEtbHAxNTIuMTYuMS54 ODZfNjQgPC9zcGFuPjxwPiZuYnNwOzxzdHJvbmc+PHNwYW4gc3R5bGU9ImNvbG9yOiNmZjU0NTQ7 Ij5wb3N0Z3Jlc3FsPC9zcGFuPjwvc3Ryb25nPjxzcGFuIHN0eWxlPSJjb2xvcjojMDAwMDAwOyI+ LWNvbnRyaWItMTMtbHAxNTIuMy4xLm5vYXJjaCA8L3NwYW4+PHA+Jm5ic3A7PHN0cm9uZz48c3Bh biBzdHlsZT0iY29sb3I6I2ZmNTQ1NDsiPnBvc3RncmVzcWw8L3NwYW4+PC9zdHJvbmc+PHNwYW4g c3R5bGU9ImNvbG9yOiMwMDAwMDA7Ij4xMi1pcDRyLWxsdm1qaXQtMi40LjErZ2l0MS41ZjljZTg4 LWxwMTUyLjguMi54ODZfNjQgPC9zcGFuPjxwPiZuYnNwOzxzdHJvbmc+PHNwYW4gc3R5bGU9ImNv bG9yOiNmZjU0NTQ7Ij5wb3N0Z3Jlc3FsPC9zcGFuPjwvc3Ryb25nPjxzcGFuIHN0eWxlPSJjb2xv cjojMDAwMDAwOyI+MTMtMTMuMS1scDE1Mi4xNi4xLng4Nl82NCA8L3NwYW4+PHA+Jm5ic3A7PHN0 cm9uZz48c3BhbiBzdHlsZT0iY29sb3I6I2ZmNTQ1NDsiPnBvc3RncmVzcWw8L3NwYW4+PC9zdHJv bmc+PHNwYW4gc3R5bGU9ImNvbG9yOiMwMDAwMDA7Ij4xMy1sbHZtaml0LTEzLjEtbHAxNTIuMTYu MS54ODZfNjQgPC9zcGFuPjxwPiZuYnNwOzxzdHJvbmc+PHNwYW4gc3R5bGU9ImNvbG9yOiNmZjU0 NTQ7Ij5wb3N0Z3Jlc3FsPC9zcGFuPjwvc3Ryb25nPjxzcGFuIHN0eWxlPSJjb2xvcjojMDAwMDAw OyI+LXBscGVybC0xMy1scDE1Mi4zLjEubm9hcmNoIDwvc3Bhbj48cD4mbmJzcDs8c3Ryb25nPjxz cGFuIHN0eWxlPSJjb2xvcjojZmY1NDU0OyI+cG9zdGdyZXNxbDwvc3Bhbj48L3N0cm9uZz48c3Bh biBzdHlsZT0iY29sb3I6IzAwMDAwMDsiPjEyLXBsZGVidWdnZXItbGx2bWppdC0xLjArZ2l0MTMu ZGRiY2U3Yi1scDE1Mi4xLjQueDg2XzY0IDwvc3Bhbj48cD4mbmJzcDs8c3Ryb25nPjxzcGFuIHN0 eWxlPSJjb2xvcjojZmY1NDU0OyI+cG9zdGdyZXNxbDwvc3Bhbj48L3N0cm9uZz48c3BhbiBzdHls ZT0iY29sb3I6IzAwMDAwMDsiPjEzLWNvbnRyaWItMTMuMS1scDE1Mi4xNi4xLng4Nl82NDwvc3Bh bj48cD4mbmJzcDs8L3A+CjxwIHN0eWxlPSJtYXJnaW4tdG9wOjA7bWFyZ2luLWJvdHRvbTowO21h cmdpbi1sZWZ0OjA7bWFyZ2luLXJpZ2h0OjA7Ij5PdXRwdXQgZnJvbSBmYWlsZWQgZGF0YWJhc2Ug dXBncmFkZTo8L3A+CjxwIHN0eWxlPSJtYXJnaW4tdG9wOjA7bWFyZ2luLWJvdHRvbTowO21hcmdp bi1sZWZ0OjA7bWFyZ2luLXJpZ2h0OjA7Ij5ib3RkYj0jIFxkTCA8cD4mbmJzcDs8L3A+CjxiciAv PjxiciAvPjxiciAvPjxiciAvPjxiciAvPjwvYm9keT4KPC9odG1sPg== --nextPart3604603.kQq0lBPeGt-- --nextPart3374733.iIbC2pHGDl 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"; --nextPart3374733.iIbC2pHGDl--