From: | Osahon Oduware <osahon(dot)gis(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Build PostgreSQL With XML Support on Linux |
Date: | 2017-05-31 13:24:03 |
Message-ID: | CAGpiUShEa4To2WifsSz5PCHsVhZyoBfoQuHeGxODnn-rSxnPUw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All,
I successfully built PostgreSQL from source on Linux (Centos 7) using the
following:
./configure --prefix=/home/nagispg/local/pgsql --with-libxml --with-libxslt
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
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2017-05-31 13:34:38 | Re: Build PostgreSQL With XML Support on Linux |
Previous Message | tel medola | 2017-05-31 13:05:06 | Redo the filenode link in tablespace |