Re: why can't I load pgxml.sql

Yi Zhao <yi.zhao@alibaba-inc.com> writes:
> 1. ./configure --with-libxml --with-libxslt
> 2. make&&make install (successful)
> 3. test=# \i /usr/local/pgsql/share/contrib/pgxml.sql

> error appearance:
> SET
> psql:/usr/local/pgsql/share/contrib/pgxml.sql:10: ERROR:  could not load
> library "/usr/local/pgsql/lib/pgxml.so": /usr/lib/libxml2.so.2:
> undefined symbol: gzopen64

Well, you've still failed to mention most all of the relevant
information, like what platform this is and what PG version.
But what the above suggests is that libxml2 is linked to a
version of libz that doesn't appear anywhere in the dynamic
linker's search path.  How did you obtain or build libxml2,
exactly?  If this is a Linux platform, I think you might have
missed out a ldconfig call or two.

            regards, tom lane