Re: [GENERAL] Postgres 10 Beta1 - pg_upgrade fails on Windows 10 - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: [GENERAL] Postgres 10 Beta1 - pg_upgrade fails on Windows 10
Date
Msg-id og9voa$sgh$1@blaine.gmane.org
Whole thread Raw
In response to Re: [GENERAL] Postgres 10 Beta1 - pg_upgrade fails on Windows 10  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [GENERAL] Postgres 10 Beta1 - pg_upgrade fails on Windows 10  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
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.

>> When I then run pg_upgrade without the --check option, it fails when taking the schema only dump from one database.
>> The error message reported in the logfile is:
>>     pg_dump: unrecognized collation provider: p
>
> Ugh :-( ... seems like a rather obvious typo in dumpCollation().
> Thanks for finding it!



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Postgres 10 Beta1 - pg_upgrade fails on Windows 10
Next
From: Alvaro Herrera
Date:
Subject: Re: [GENERAL] Postgres 10 Beta1 - pg_upgrade fails on Windows 10