Adrian Klaver schrieb am 26.05.2017 um 23:16:
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?
Interesting enough, the same error message appears when I run "create extension xml2;" on Postgres 10.
It somehow looks as if there is a DLL dependency between XML2 and whatever uses pgxml.dll (the new xmltable perhaps?)
from a 9.6 instance of unknown provenance
The 9.6 installation is a 9.6.2 binary from EnterpriseDB (unfortunately they don't supply the beta binaries, otherwise I would have used those)
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
