Skip site navigation (1) Skip section navigation (2)

Problem getting xml2 contrib module working with 8.1

From: George Weaver <gweaver(at)shaw(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Problem getting xml2 contrib module working with 8.1
Date: 2005-11-16 22:59:06
Message-ID: 000901c5eb01$5b3323e0$6400a8c0@Dell4500 (view raw or flat)
Lists: pgsql-novice

I have used the xml2 contrib module successfully with postgresql versions starting with 7.3, although installing the module at times has proven challenging.  I have been using the xml2 contrib module most recently on 8.0.0.

I have installed 8.1.1 on an X/P machine (installation was a breeze using the binary installer!).  Using the following steps which have worked in the past I undertook to install the xml2 contrib module:

1. Downloaded the source tree for 8.1.0.

2. Downloaded the most recent versions of libxml2, libxslt and libexslt, and installed the appropriate header file directories in the  "C:\Program Files\PostgreSQL\postgresql-8.1.0\src\include" directory, and the appropriate dll's in the "C:\Program Files\PostgreSQL\postgresql-8.1.0\src\port" and  "C:\Program Files\PostgreSQL\8.1\lib" directories

3. Using the mingw32 shell ran configure.

4. Checked to make sure configure worked by running make - make completed successfully: "All of PostgreSQL successfully made. Ready to install."

5. Using the mingw32 shell ran make for the xml2 module.  The following are the results:

$ make
sed 's,MODULE_PATHNAME,$libdir/pgxml,g' >pgxml.sql
make: xml2-config: Command not found
gcc   -I. -I../../src/include -I./src/include/port/win32 -DEXEC_BACKEND  "-I../../src/include/port/win32"  -c -o xpath.o xpath.c
make: xml2-config: Command not found
gcc   -I. -I../../src/include -I./src/include/port/win32 -DEXEC_BACKEND  "-I../../src/include/port/win32"  -c -o xslt_proc.o xslt_proc.c
dlltool --export-all  --output-def pgxml.def xpath.o xslt_proc.o
dllwrap  -o libpgxml.dll --dllname libpgxml.dll  --def pgxml.def xpath.o xslt_proc.o -L../../src/backend -L../../src/port -lxml2 -lxslt -lpostgres 
dlltool --dllname libpgxml.dll  --def pgxml.def --output-lib libpgxml.a

I am not sure about the message "xml2-config: Command not found", but libpgxml.dll appears to have been created successfully.  I copied libpgxml.dll to the "C:\Program Files\PostgreSQL\8.1\lib" directory.

When I tried to install the functions in the file "pgxml.sql" I get the following error for each function:

"psql:C:/Program Files/PostgreSQL/postgresql-8.1.0/contrib/xml2/pgxml.sql:4: ERROR:  could not load library "C:/Program Files/PostgreSQL/8.1/lib/libpgxml.dll": The specified module could not be found."

Any thoughts as to why these steps have worked to date, but not now, and what I should do to resolve the problem?

Thanks in advance,


pgsql-novice by date

Next:From: ryan millerDate: 2005-11-16 23:02:04
Subject: pg_connect works, DBI::connect says permission denied
Previous:From: Michael GlaesemannDate: 2005-11-16 22:14:23
Subject: Re: createdb Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group