Issues with Redhat 4 Postgresql 8.4 and support of libxml

Started by Ale Razaover 16 years ago8 messagesgeneral

araza@esri.com

over 16 years ago

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.

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.

Import Notes

Reply to msg id not found: 200911191833.nAJIXwMR027428@doubleblack.esri.comReference msg id not found: 200911191833.nAJIXwMR027428@doubleblack.esri.com

Joshua D. Drake

jd@commandprompt.com

over 16 years ago

In reply to: Ale Raza (#1)

Re: 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.

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

Devrim GÜNDÜZ

devrim@gunduz.org

over 16 years ago

In reply to: Ale Raza (#1)

Re: 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 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

Ale Raza

araza@esri.com

over 16 years ago

In reply to: Joshua D. Drake (#2)

Re: Issues with Redhat 4 Postgresql 8.4 and support of libxml

"...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 still getting 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.

Ale Raza

araza@esri.com

over 16 years ago

In reply to: Devrim GÜNDÜZ (#3)

Re: Issues with Redhat 4 Postgresql 8.4 and support of libxml

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

Devrim GÜNDÜZ

devrim@gunduz.org

over 16 years ago

In reply to: Ale Raza (#4)

Re: 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

Ale Raza

araza@esri.com

over 16 years ago

In reply to: Devrim GÜNDÜZ (#6)

Re: Issues with Redhat 4 Postgresql 8.4 and support of libxml

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

Tom Lane

tgl@sss.pgh.pa.us

over 16 years ago

In reply to: Ale Raza (#1)

Re: Issues with Redhat 4 Postgresql 8.4 and support of libxml

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 still getting 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