RE: Help needed configuring postgreSQL with xml support

Thanks for the quick response. I am using RED HAT linux ( ppc64-le ).

Operating System: Red Hat Enterprise Linux Server 7.9 Beta (Maipo)
CPE OS Name: cpe:/o:redhat:enterprise_linux:7.9:beta:server
Kernel: Linux 3.10.0-1136.el7.ppc64le
Architecture: ppc64-le
You have new mail in /var/spool/mail/root

I have gone into the details given for xml support and have installed the required rpm and tried to setup the env variables as well like

export XML2_CFLAGS='/usr/lib64/'
export XML2_CONFIG='/usr/lib64/'
export XML2_LIBS='/usr/lib64/libxml2.so.2.9.1'

rpm -qi libxml2-2.9.1-6.el7.4.ppc64le
Name : libxml2
Version : 2.9.1
Release : 6.el7.4
Architecture: ppc64le
Install Date: Thu 09 Jul 2020 02:55:33 PM CDT
Group : Development/Libraries
Size : 2594518

yum list installed |grep xml
libxml2.ppc64le 2.9.1-6.el7.4 @anaconda/7.9
libxml2-python.ppc64le 2.9.1-6.el7.4 @anaconda/7.9
python-lxml.ppc64le 3.2.1-4.el7 @anaconda/7.9
xml-common.noarch 0.6.3-39.el7 @anaconda/7.9
xml2.ppc64le 0.5-7.el7 @epel
xmlrpc-c.ppc64le 1.32.5-1905.svn2451.el7 @anaconda/7.9
xmlrpc-c-client.ppc64le 1.32.5-1905.svn2451.el7 @anaconda/7.9

--with-libxml
Build with libxml2, enabling SQL/XML support. Libxml2 version 2.6.23 or later is required for this feature.

To detect the required compiler and linker options, PostgreSQL will query pkg-config, if that is installed and knows about libxml2. Otherwise the program xml2-config, which is installed by libxml2, will be used if it is found. Use of pkg-config is preferred, because it can deal with multi-architecture installations better.

To use a libxml2 installation that is in an unusual location, you can set pkg-config-related environment variables (see its documentation), or set the environment variable XML2_CONFIG to point to the xml2-config program belonging to the libxml2 installation, or set the variables XML2_CFLAGS and XML2_LIBS. (If pkg-config is installed, then to override its idea of where libxml2 is you must either set XML2_CONFIG or set both XML2_CFLAGS and XML2_LIBS to nonempty strings.)

Thanks and Regards,
SACHIN KHANNA
212 BASIS DBA TEAM OFFSHORE
Office : 204058624
Cell : 9049522511

-----Original Message-----
From: Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>
Sent: Thursday, August 27, 2020 2:12 PM
To: Khanna, Sachin 000 <Sachin(dot)Khanna(at)sysco(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org; Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Subject: Re: Help needed configuring postgreSQL with xml support

EXTERNAL EMAIL: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe

In addition to what Thomas said, I would also recommend you to refer to the description of --with-libxml command line option provided in the postgres installation-procedure page - [1].

[1] - https://urldefense.proofpoint.com/v2/url?u=https-3A__www.postgresql.org_docs_12_install-2Dprocedure.html&d=DwIBaQ&c=Iej4I5bEYPmgv5l2sS6i8A&r=RbbcFo0QGVsZI41vIxHdvJHDEomAuf-kGUMMC7Yn2sE&m=D5QMYkp-FOKiI-htZxXqsxkhULT3OKhPaZbElnB9CWY&s=oDlVjDkRb48Sqx0fUgv6hoehucADn74yxrut4uiL50E&e=

--
With Regards,
Ashutosh Sharma
EnterpriseDB:https://urldefense.proofpoint.com/v2/url?u=http-3A__www.enterprisedb.com&d=DwIBaQ&c=Iej4I5bEYPmgv5l2sS6i8A&r=RbbcFo0QGVsZI41vIxHdvJHDEomAuf-kGUMMC7Yn2sE&m=D5QMYkp-FOKiI-htZxXqsxkhULT3OKhPaZbElnB9CWY&s=vhT8MXXxy_b8UWkK9HhFKfoRwA8BRWxLEk0s0QcCk_I&e=

On Thu, Aug 27, 2020 at 1:56 PM Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:
>
> On Thu, Aug 27, 2020 at 8:17 PM Khanna, Sachin 000
> <Sachin(dot)Khanna(at)sysco(dot)com> wrote:
> > I am getting following error in configuration.log of installation .
> > Please help
>
> You didn't mention what operating system this is, but, for example, if
> it's Debian, Ubuntu or similar you might need to install libxml2-dev
> and pkg-config for --with-libxml to work.
>
>