Thread: Issues with Redhat 4 Postgresql 8.4 and support of libxml
What are the issues with Redhat 4 in terms of supporting libxml? I build PostgreSQL 8.4 with --with-libxml option but
stillgetting the following error.
STATEMENT: INSERT INTO test VALUES (1, '<foo>abc</foo>');
ERROR: unsupported XML feature
LINE 1: INSERT INTO test VALUES (1, '<foo>abc</foo>');
^
DETAIL: This functionality requires the server to be built with libxml support.
HINT: You need to rebuild PostgreSQL using --with-libxml.
This is what I have done.
1- ./configure --prefix=/net/volks/volks2/pg84 --with-libxml
2- gmake
3- gmake install
This is where I have my libxml2 lib
>ls -l /usr/lib/libxml*.so*
lrwxrwxrwx 1 root root 25 Nov 19 11:08 /usr/lib/libxml2.so -> /usr/local/lib/libxml2.so
lrwxrwxrwx 1 root root 27 Nov 19 11:08 /usr/lib/libxml2.so.2 -> /usr/local/lib/libxml2.so.2
lrwxrwxrwx 1 root root 20 Dec 28 2007 /usr/lib/libxmlparse.so.0 -> libxmlparse.so.0.1.0
-rwxr-xr-x 1 root root 32456 Nov 15 2006 /usr/lib/libxmlparse.so.0.1.0
lrwxrwxrwx 1 root root 18 Dec 28 2007 /usr/lib/libxmltok.so.0 -> libxmltok.so.0.1.0
-rwxr-xr-x 1 root root 75576 Nov 15 2006 /usr/lib/libxmltok.so.0.1.0
> ls -l /usr/local/lib/libxml2.so
lrwxrwxrwx 1 root root 17 Nov 19 10:29 /usr/local/lib/libxml2.so -> libxml2.so.2.6.30
> ls -l /usr/local/lib/libxml2.so.2
lrwxrwxrwx 1 root root 17 Nov 19 10:29 /usr/local/lib/libxml2.so.2 -> libxml2.so.2.6.32
I built libxml2.so (version 2.6.30) from source code.
Thanks for any help.
Ale Raza.
On Thu, 2009-11-19 at 12:05 -0800, araza@esri.com wrote: > What are the issues with Redhat 4 in terms of supporting libxml? I build PostgreSQL 8.4 with --with-libxml option but stillgetting the following error. You probably need to tell postgresql to compile against the specific new version of libxml that you built from source. > > STATEMENT: INSERT INTO test VALUES (1, '<foo>abc</foo>'); > ERROR: unsupported XML feature > LINE 1: INSERT INTO test VALUES (1, '<foo>abc</foo>'); > ^ > DETAIL: This functionality requires the server to be built with libxml support. > HINT: You need to rebuild PostgreSQL using --with-libxml. > > This is what I have done. > > 1- ./configure --prefix=/net/volks/volks2/pg84 --with-libxml > 2- gmake > 3- gmake install > > This is where I have my libxml2 lib > >ls -l /usr/lib/libxml*.so* > lrwxrwxrwx 1 root root 25 Nov 19 11:08 /usr/lib/libxml2.so -> /usr/local/lib/libxml2.so > lrwxrwxrwx 1 root root 27 Nov 19 11:08 /usr/lib/libxml2.so.2 -> /usr/local/lib/libxml2.so.2 > lrwxrwxrwx 1 root root 20 Dec 28 2007 /usr/lib/libxmlparse.so.0 -> libxmlparse.so.0.1.0 > -rwxr-xr-x 1 root root 32456 Nov 15 2006 /usr/lib/libxmlparse.so.0.1.0 > lrwxrwxrwx 1 root root 18 Dec 28 2007 /usr/lib/libxmltok.so.0 -> libxmltok.so.0.1.0 > -rwxr-xr-x 1 root root 75576 Nov 15 2006 /usr/lib/libxmltok.so.0.1.0 > > > > ls -l /usr/local/lib/libxml2.so > lrwxrwxrwx 1 root root 17 Nov 19 10:29 /usr/local/lib/libxml2.so -> libxml2.so.2.6.30 > > ls -l /usr/local/lib/libxml2.so.2 > lrwxrwxrwx 1 root root 17 Nov 19 10:29 /usr/local/lib/libxml2.so.2 -> libxml2.so.2.6.32 > > I built libxml2.so (version 2.6.30) from source code. > > Thanks for any help. > > Ale Raza. > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering If the world pushes look it in the eye and GRR. Then push back harder. - Salamander
On Thu, 2009-11-19 at 12:05 -0800, araza@esri.com wrote: > What are the issues with Redhat 4 in terms of supporting libxml? I > build PostgreSQL 8.4 with --with-libxml option but still getting the > following error. If you are using libxml2-devel package from Red Hat repository, it won't work. The libxml2 version in RHEL4 is not enough for xml support. Either upgrade to RHEL5, or compile a newer version of libxml2 on your system and build PostgreSQL against it. Regards, (The PostgreSQL packager) -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachment
"...compile against the specific new version of libxml.." And where I can specify this version? I already tried --with-includes and --with-libraries option. Ale. -----Original Message----- From: Joshua D. Drake [mailto:jd@commandprompt.com] Sent: Thursday, November 19, 2009 12:40 PM To: Ale Raza Cc: 'pgsql-general@postgresql.org' Subject: Re: [GENERAL] Issues with Redhat 4 Postgresql 8.4 and support of libxml On Thu, 2009-11-19 at 12:05 -0800, araza@esri.com wrote: > What are the issues with Redhat 4 in terms of supporting libxml? I build PostgreSQL 8.4 with --with-libxml option but stillgetting the following error. You probably need to tell postgresql to compile against the specific new version of libxml that you built from source. > > STATEMENT: INSERT INTO test VALUES (1, '<foo>abc</foo>'); > ERROR: unsupported XML feature > LINE 1: INSERT INTO test VALUES (1, '<foo>abc</foo>'); > ^ > DETAIL: This functionality requires the server to be built with libxml support. > HINT: You need to rebuild PostgreSQL using --with-libxml. > > This is what I have done. > > 1- ./configure --prefix=/net/volks/volks2/pg84 --with-libxml > 2- gmake > 3- gmake install > > This is where I have my libxml2 lib > >ls -l /usr/lib/libxml*.so* > lrwxrwxrwx 1 root root 25 Nov 19 11:08 /usr/lib/libxml2.so -> /usr/local/lib/libxml2.so > lrwxrwxrwx 1 root root 27 Nov 19 11:08 /usr/lib/libxml2.so.2 -> /usr/local/lib/libxml2.so.2 > lrwxrwxrwx 1 root root 20 Dec 28 2007 /usr/lib/libxmlparse.so.0 -> libxmlparse.so.0.1.0 > -rwxr-xr-x 1 root root 32456 Nov 15 2006 /usr/lib/libxmlparse.so.0.1.0 > lrwxrwxrwx 1 root root 18 Dec 28 2007 /usr/lib/libxmltok.so.0 -> libxmltok.so.0.1.0 > -rwxr-xr-x 1 root root 75576 Nov 15 2006 /usr/lib/libxmltok.so.0.1.0 > > > > ls -l /usr/local/lib/libxml2.so > lrwxrwxrwx 1 root root 17 Nov 19 10:29 /usr/local/lib/libxml2.so -> libxml2.so.2.6.30 > > ls -l /usr/local/lib/libxml2.so.2 > lrwxrwxrwx 1 root root 17 Nov 19 10:29 /usr/local/lib/libxml2.so.2 -> libxml2.so.2.6.32 > > I built libxml2.so (version 2.6.30) from source code. > > Thanks for any help. > > Ale Raza. > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering If the world pushes look it in the eye and GRR. Then push back harder. - Salamander
I am not using libxml2-devel package. I built libxml2.so from source code (libxml2-2.6.30.tar.gz). Thanks. Ale. -----Original Message----- From: Devrim GÜNDÜZ [mailto:devrim@gunduz.org] Sent: Thursday, November 19, 2009 2:59 PM To: Ale Raza Cc: 'pgsql-general@postgresql.org' Subject: Re: [GENERAL] Issues with Redhat 4 Postgresql 8.4 and support of libxml On Thu, 2009-11-19 at 12:05 -0800, araza@esri.com wrote: > What are the issues with Redhat 4 in terms of supporting libxml? I > build PostgreSQL 8.4 with --with-libxml option but still getting the > following error. If you are using libxml2-devel package from Red Hat repository, it won't work. The libxml2 version in RHEL4 is not enoughfor xml support. Either upgrade to RHEL5, or compile a newer version of libxml2 on your system and build PostgreSQL against it. Regards, (The PostgreSQL packager) -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
On Thu, 2009-11-19 at 15:22 -0800, araza@esri.com wrote: > And where I can specify this version? I already tried --with-includes > and --with-libraries option. Please show us complete configure line. -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachment
I tried all three combinations. ./configure --prefix=/net/volks/volks2/pg84 --with-libxml ./configure --prefix=/net/volks/volks2/pg84 --with-includes=/usr/local/include/libxml2/libxml --with-libraries=/usr/local/lib ./configure --prefix=/net/volks/volks2/pg84 --with-includes=/usr/local/include/libxml2/libxml --with-libraries=/usr/local/lib--with-libxml Further directories information: > ls /usr/local/include/libxml2/libxml c14n.h encoding.h list.h relaxng.h tree.h xmlerror.h xmlregexp.h xmlversion.h catalog.h entities.h nanoftp.h SAX2.h uri.h xmlexports.h xmlsave.h xmlwriter.h chvalid.h globals.h nanohttp.h SAX.h valid.h xmlIO.h xmlschemas.h xpath.h debugXML.h hash.h parser.h schemasInternals.h xinclude.h xmlmemory.h xmlschemastypes.h xpathInternals.h dict.h HTMLparser.h parserInternals.h schematron.h xlink.h xmlmodule.h xmlstring.h xpointer.h DOCBparser.h HTMLtree.h pattern.h threads.h xmlautomata.h xmlreader.h xmlunicode.h > ls /usr/local/lib libgeos-3.0.0rc4.so libgeos_c.la libgeos_c.so.1.3.3 libproj.a libproj.so.0 libxml2.la libxml2.so.2.6.30 python2.2 libgeos.a libgeos_c.so libgeos.la libproj.la libproj.so.0.5.2 libxml2.so libxml2.so.2.6.32 python2.3 libgeos_c.a Ale. -----Original Message----- From: Devrim GÜNDÜZ [mailto:devrim@gunduz.org] Sent: Thursday, November 19, 2009 3:49 PM To: Ale Raza Cc: 'jd@commandprompt.com'; 'pgsql-general@postgresql.org' Subject: Re: [GENERAL] Issues with Redhat 4 Postgresql 8.4 and support of libxml On Thu, 2009-11-19 at 15:22 -0800, araza@esri.com wrote: > And where I can specify this version? I already tried --with-includes > and --with-libraries option. Please show us complete configure line. -- Devrim GÜNDÜZ, RHCE Command Prompt - http://www.CommandPrompt.com devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
On Thu, 2009-11-19 at 12:05 -0800, araza@esri.com wrote: > What are the issues with Redhat 4 in terms of supporting libxml? I build PostgreSQL 8.4 with --with-libxml option but stillgetting the following error. You probably need to tell postgresql to compile against the specific new version of libxml that you built from source. > > STATEMENT: INSERT INTO test VALUES (1, '<foo>abc</foo>'); > ERROR: unsupported XML feature > LINE 1: INSERT INTO test VALUES (1, '<foo>abc</foo>'); > ^ > DETAIL: This functionality requires the server to be built with libxml support. > HINT: You need to rebuild PostgreSQL using --with-libxml. > > This is what I have done. > > 1- ./configure --prefix=/net/volks/volks2/pg84 --with-libxml > 2- gmake > 3- gmake install > > This is where I have my libxml2 lib > >ls -l /usr/lib/libxml*.so* > lrwxrwxrwx 1 root root 25 Nov 19 11:08 /usr/lib/libxml2.so -> /usr/local/lib/libxml2.so > lrwxrwxrwx 1 root root 27 Nov 19 11:08 /usr/lib/libxml2.so.2 -> /usr/local/lib/libxml2.so.2 > lrwxrwxrwx 1 root root 20 Dec 28 2007 /usr/lib/libxmlparse.so.0 -> libxmlparse.so.0.1.0 > -rwxr-xr-x 1 root root 32456 Nov 15 2006 /usr/lib/libxmlparse.so.0.1.0 > lrwxrwxrwx 1 root root 18 Dec 28 2007 /usr/lib/libxmltok.so.0 -> libxmltok.so.0.1.0 > -rwxr-xr-x 1 root root 75576 Nov 15 2006 /usr/lib/libxmltok.so.0.1.0 > > > > ls -l /usr/local/lib/libxml2.so > lrwxrwxrwx 1 root root 17 Nov 19 10:29 /usr/local/lib/libxml2.so -> libxml2.so.2.6.30 > > ls -l /usr/local/lib/libxml2.so.2 > lrwxrwxrwx 1 root root 17 Nov 19 10:29 /usr/local/lib/libxml2.so.2 -> libxml2.so.2.6.32 > > I built libxml2.so (version 2.6.30) from source code. > > Thanks for any help. > > Ale Raza. > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering If the world pushes look it in the eye and GRR. Then push back harder. - Salamander
araza@esri.com writes:
> What are the issues with Redhat 4 in terms of supporting libxml? I build PostgreSQL 8.4 with --with-libxml option but
stillgetting the following error.
> STATEMENT: INSERT INTO test VALUES (1, '<foo>abc</foo>');
> ERROR: unsupported XML feature
> LINE 1: INSERT INTO test VALUES (1, '<foo>abc</foo>');
> ^
> DETAIL: This functionality requires the server to be built with libxml support.
> HINT: You need to rebuild PostgreSQL using --with-libxml.
I think you are not actually running the version you built.
It should not be possible to get that error out of a backend that
was built with --with-libxml. If it couldn't find libxml, or
found a version that was too old, the complaints would look different
than this.
Did you install the new version? restart the server?
make sure you are connecting to that server and not some other one?
regards, tom lane