I am using PostgreSQL 9.6.2 On Wed, May 31, 2017 at 2:34 PM, Adrian Klaver <adrian.kla...@aklaver.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.kla...@aklaver.com >