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

2022-10-13 Thread Adrian Klaver
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 o

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

2022-10-13 Thread Thomas Kellerer
Tom Lane schrieb am 13.10.2022 um 21:01: When trying pg_upgrade to upgrade Postgres 14 to 15 on Windows 10 this fails with: pg_restore: error: could not execute query: ERROR: could not find function "xml_is_well_formed" in file "c:/Program Files/PostgreSQL/15/lib/pgxml.dll" I don't understa

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

2022-10-13 Thread Tom Lane
Thomas Kellerer writes: > When trying pg_upgrade to upgrade Postgres 14 to 15 on Windows 10 this fails > with: > pg_restore: error: could not execute query: ERROR: could not find function > "xml_is_well_formed" in file "c:/Program Files/PostgreSQL/15/lib/pgxml.dll" > I don't understand why thi

pg_upgrade to 15 fails on Windows because of xml_is_well_formed()

2022-10-13 Thread Thomas Kellerer
When trying pg_upgrade to upgrade Postgres 14 to 15 on Windows 10 this fails with: pg_restore: creating FUNCTION "public.xml_is_well_formed("text")" pg_restore: while PROCESSING TOC: pg_restore: from TOC entry 647; 1255 23216 FUNCTION xml_is_well_formed("text") postgres pg_restore: error: could