Thread: Help needed configuring postgreSQL with xml support

Help needed configuring postgreSQL with xml support

From
"Khanna, Sachin 000"
Date:

 

 

I am getting following error in  configuration.log of installation . Please help

 

Is there any pkg-config path that needs to be configured/set in environment for this to work.

 

configure:8172: checking for libxml-2.0 >= 2.6.23

configure:8179: $PKG_CONFIG --exists --print-errors "libxml-2.0 >= 2.6.23"

Package libxml-2.0 was not found in the pkg-config search path.

Perhaps you should add the directory containing `libxml-2.0.pc'

to the PKG_CONFIG_PATH environment variable

No package 'libxml-2.0' found

configure:8182: $? = 1

configure:8196: $PKG_CONFIG --exists --print-errors "libxml-2.0 >= 2.6.23"

Package libxml-2.0 was not found in the pkg-config search path.

Perhaps you should add the directory containing `libxml-2.0.pc'

to the PKG_CONFIG_PATH environment variable

No package 'libxml-2.0' found

configure:8199: $? = 1

configure:8213: result: no

No package 'libxml-2.0' found

 

I later tried setting the some environment variables like

 

 

export XML2_CFLAGS='/usr/lib64/'

export XML2_CONFIG='/usr/lib64/'

export XML2_LIBS='/usr/lib64/libxml2

 

Created soft link as well libxml2.so -> /usr/lib64/libxml2.so.2.9.1 but now I getting the below error .

 

configure: error: header file <libxml/parser.h> is required for XML support

 

From config.log

 

configure:13266: checking libxml/parser.h usability

configure:13266: gcc -std=gnu99 -c -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2  -D_GNU_SOURCE  conftest.c >&5

conftest.c:96:27: fatal error: libxml/parser.h: No such file or directory

#include <libxml/parser.h>

                           ^

compilation terminated.

configure:13266: $? = 1

configure: failed program was:

 

 

 

 

Thanks and Regards,                                                        
SACHIN KHANNA
212 Basis Offshore DBA
Office : 204058624
Cell : 9049522511
Email: khanna.sachin@corp.sysco.com

ITIL V3 (F), AWS Certified Solution Archtect

Infosys Technologies Limited ® | PUNE

 

Re: Help needed configuring postgreSQL with xml support

From
Thomas Munro
Date:
On Thu, Aug 27, 2020 at 8:17 PM Khanna, Sachin 000
<Sachin.Khanna@sysco.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.



Re: Help needed configuring postgreSQL with xml support

From
Ashutosh Sharma
Date:
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://www.postgresql.org/docs/12/install-procedure.html

--
With Regards,
Ashutosh Sharma
EnterpriseDB:http://www.enterprisedb.com

On Thu, Aug 27, 2020 at 1:56 PM Thomas Munro <thomas.munro@gmail.com> wrote:
>
> On Thu, Aug 27, 2020 at 8:17 PM Khanna, Sachin 000
> <Sachin.Khanna@sysco.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.
>
>



RE: Help needed configuring postgreSQL with xml support

From
Sachin Khanna
Date:
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
variablesas 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
aboutlibxml2. Otherwise the program xml2-config, which is installed by libxml2, will be used if it is found. Use of
pkg-configis 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
itsdocumentation), or set the environment variable XML2_CONFIG to point to the xml2-config program belonging to the
libxml2installation, or set the variables XML2_CFLAGS and XML2_LIBS. (If pkg-config is installed, then to override its
ideaof 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.coek88@gmail.com> 
Sent: Thursday, August 27, 2020 2:12 PM
To: Khanna, Sachin 000 <Sachin.Khanna@sysco.com>
Cc: pgsql-hackers@postgresql.org; Thomas Munro <thomas.munro@gmail.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
yourecognize 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
optionprovided 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.munro@gmail.com> wrote:
>
> On Thu, Aug 27, 2020 at 8:17 PM Khanna, Sachin 000 
> <Sachin.Khanna@sysco.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.
>
>