Re: pg_upgrade to 15 fails on Windows because of xml_is_well_formed()

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Thomas Kellerer <shammat(at)gmx(dot)net>, Postgres General <pgsql-general(at)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: pg_upgrade to 15 fails on Windows because of xml_is_well_formed()
Date: 2022-10-13 19:53:24
Message-ID: e35f1098-7c27-5f9e-f738-dc3afccf9258@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/13/22 12:45, Thomas Kellerer wrote:
> Tom Lane schrieb am 13.10.2022 um 21:01:
>>> When trying pg_upgrade to upgrade Postgres 14 to 15 on Windows 10

> Hmm, the xml2 extension is not installed in any of those databases.
>
> Most databases were probably migrated over time from 8.4
> and I can't rule out that I did install xml2 there at some time
> in the past.
>
> I checked pg_proc and it the function was there twice: one in pg_catalog
> and one in the public schema.

The one in the public schema would seem to be the smoking gun that
points at xml2 having been installed from contrib in pre-extension days.

> Regards
> Thomas
>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Erik Wienhold 2022-10-13 20:07:33 Re: Exponentiation confusion
Previous Message Thomas Kellerer 2022-10-13 19:45:16 Re: pg_upgrade to 15 fails on Windows because of xml_is_well_formed()