From: GMX LINREG <linreg@gmx.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16843: pg_upgrade from 12.5 to 13.1 with extension plperlu failed
Date: Mon, 01 Feb 2021 16:23:47 +0100
Message-ID: <4296093.LvFx2qVVIh@wolfclan.ang.de> (raw)
In-Reply-To: <2816651.1611942942@sss.pgh.pa.us>
References: <16843-174d3e5b66729a60@postgresql.org>
<5448993.DvuYhMxLoT@wolfclan.ang.de>
<2816651.1611942942@sss.pgh.pa.us>
Am Freitag, 29. Januar 2021, 18:55:42 CET schrieb Tom Lane:
> GMX LINREG <linreg@gmx.net> writes:
> > output from source database:
> > botdb=# \dx+ plperlu
> > Objekte in Erweiterung »plperlu«
> >
> > Objektbeschreibung
> >
> > --------------------
> >
> > language plperlu
>
> Yeah, that's definitely broken: it should look like
>
> \dx+ plperlu
> Objects in extension "plperlu"
> Object description
> -------------------------------------------
> function plperlu_call_handler()
> function plperlu_inline_handler(internal)
> function plperlu_validator(oid)
> language plperlu
> (4 rows)
>
> Offhand I think that completely explains pg_dump's failure: it relies on
> the dependency-membership entries to decide that it ought to dump the
> language support functions, so if they're not there, this is what you get.
>
> It's possible that the entries *are* there but they're not being found due
> to index corruption. You could try "REINDEX TABLE pg_depend" and see if
> the \dx+ output changes. I don't have a lot of hope for that though.
>
> The next easiest fix would be to see if you have any plperlu functions
> to worry about, and if not, just drop the busted extension.
>
> If you do have some such functions, the best bet might be to dump
> them separately, go ahead and DROP CASCADE the busted extension,
> then upgrade; and restore the plperlu functions separately afterwards.
>
> It'd be kind of interesting to figure out why those pg_depend entries
> are missing, but I suppose the evidence is long gone :-(
>
> regards, tom lane
Hello,
after "REINDEX TABLE pg_depend" the problem still persists.
So I agree "the evidence is long gone";
I will perfrom a pg_dump/psql combo to restore and upgrade the database to
main version 13. Since version 9.6 we have had a lot of pg_upgrades.
Thank you very much.
Best regards from Germany
Thomas Steffen
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, tgl@sss.pgh.pa.us, bruce@momjian.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: <4296093.LvFx2qVVIh@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