Re: Postgres 10 Beta1 - pg_upgrade fails on Windows 10

On 05/26/2017 01:58 PM, Alvaro Herrera wrote:
> Thomas Kellerer wrote:
>> Tom Lane schrieb am 26.05.2017 um 20:18:
>>>> I just tried pg_upgrade from the Postgres 10 Beta1 (from the BigSQL distribution) to upgrade a 9.6 cluster.
>>>> pg_upgrade --check fails with the following messages:
>>>
>>>> could not load library "$libdir/pgxml":
>>>> ERROR: could not load library "d:/etc/postgres-10/pgsql/lib/postgresql/pgxml.dll": unknown error 126
>>>
>>> Apparently BigSQL forgot to include contrib/xml2 in their distribution;
>>> you should ping them about that one.
>>
>> I wasn't sure where the problem is, I will report this to BigSQL as well.
>>
>> However, the xml2 extension is included. The extension control file as well as libxml2-2.dll.
>
> But the error message is looking for pgxml.dll, not libxml2-2.dll.
> Those are clearly different files.
>

Well Thomas is using pg_upgrade from a BigSQL 10beta1 install to upgrade
from a 9.6 instance of unknown provenance. pg_upgrade is complaining
that the 9.6 cluster has pgxml.dll whereas the 10beta1 cluster does not
even though xml2 is installed on both clusters. The question is this a
packaging oops on the part of BigSQL or something else?

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