Re: Postgres 10 Beta1 - pg_upgrade fails on Windows 10

Thomas Kellerer <spam_eater(at)gmx(dot)net> writes:
> 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.

> 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!

regards, tom lane