Re: [GENERAL] 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.klaver@aklaver.com