Re: [GENERAL] Issues with Redhat 4 Postgresql 8.4 and support of libxml
On Thu, 2009-11-19 at 12:05 -0800, ar...@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, 'fooabc/foo'); ERROR: unsupported XML feature LINE 1: INSERT INTO test VALUES (1, 'fooabc/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 root25 Nov 19 11:08 /usr/lib/libxml2.so - /usr/local/lib/libxml2.so lrwxrwxrwx 1 root root27 Nov 19 11:08 /usr/lib/libxml2.so.2 - /usr/local/lib/libxml2.so.2 lrwxrwxrwx 1 root root20 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 root18 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Issues with Redhat 4 Postgresql 8.4 and support of libxml
On Thu, 2009-11-19 at 12:05 -0800, ar...@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 signature.asc Description: This is a digitally signed message part
Re: [GENERAL] Issues with Redhat 4 Postgresql 8.4 and support of libxml
On Thu, 2009-11-19 at 15:22 -0800, ar...@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 signature.asc Description: This is a digitally signed message part
Re: [GENERAL] Issues with Redhat 4 Postgresql 8.4 and support of libxml
ar...@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, 'fooabc/foo'); ERROR: unsupported XML feature LINE 1: INSERT INTO test VALUES (1, 'fooabc/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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general