From: | Osahon Oduware <osahon(dot)gis(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Build PostgreSQL With XML Support on Linux |
Date: | 2017-05-31 14:41:00 |
Message-ID: | CAGpiUShEaUy=qXPrW6e0M8cZeVhjuVwY=T-BbacOp+C0ejC+fw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am using PostgreSQL 9.6.2
On Wed, May 31, 2017 at 2:34 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> On 05/31/2017 06:24 AM, Osahon Oduware wrote:
>
>> Hi All,
>>
>> I successfully built PostgreSQL from source on Linux (Centos 7) using the
>> following:
>>
>
> What version of Postgres?
>
> ./configure --prefix=/home/nagispg/local/pgsql --with-libxml
>> --with-libxslt
>>
>
>
> I would look in config.log in the build directory for clues.
>
>
>> Prior to this I had installed the xml and xslt packages (amongst others)
>> using:
>> yum install libxml2-devel
>> yum install libxslt-devel
>>
>> However, when I try to store XML data in a table I get an error. The log
>> file states that I need to rebuild PostgreSQL with --with-libxml.
>>
>> When I run pg_config I get the following output:
>> BINDIR = /home/nagispg/local/pgsql/bin
>> DOCDIR = /home/nagispg/local/pgsql/share/doc
>> HTMLDIR = /home/nagispg/local/pgsql/share/doc
>> INCLUDEDIR = /home/nagispg/local/pgsql/include
>> PKGINCLUDEDIR = /home/nagispg/local/pgsql/include
>> INCLUDEDIR-SERVER = /home/nagispg/local/pgsql/include/server
>> LIBDIR = /home/nagispg/local/pgsql/lib
>> PKGLIBDIR = /home/nagispg/local/pgsql/lib
>> LOCALEDIR = /home/nagispg/local/pgsql/share/locale
>> MANDIR = /home/nagispg/local/pgsql/share/man
>> SHAREDIR = /home/nagispg/local/pgsql/share
>> SYSCONFDIR = /home/nagispg/local/pgsql/etc
>> PGXS = /home/nagispg/local/pgsql/lib/pgxs/src/makefiles/pgxs.mk <
>> http://pgxs.mk>
>> CONFIGURE = '--prefix=/home/nagispg/local/pgsql'
>> CC = gcc
>> CPPFLAGS = -DFRONTEND -D_GNU_SOURCE
>> CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith
>> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
>> -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard
>> -O2
>> CFLAGS_SL = -fpic
>> LDFLAGS = -L../../src/common -Wl,--as-needed
>> -Wl,-rpath,'/home/nagispg/local/pgsql/lib',--enable-new-dtags
>> LDFLAGS_EX =
>> LDFLAGS_SL =
>> LIBS = -lpgcommon -lpgport -lz -lreadline -lrt -lcrypt -ldl -lm
>> VERSION = PostgreSQL 9.6.2
>>
>> From the above, the LIBS doesn't indicate the presence of xml or xslt
>> (i.e -lxslt -lxml2).
>>
>> Could someone point me to what I am doing wrong.
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
From | Date | Subject | |
---|---|---|---|
Next Message | Osahon Oduware | 2017-05-31 14:42:27 | Re: Build PostgreSQL With XML Support on Linux |
Previous Message | PAWAN SHARMA | 2017-05-31 14:36:31 | Ora2Pg-Database migration report |