Build PostgreSQL With XML Support on Linux

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Build PostgreSQL With XML Support on Linux

Osahon Oduware
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.


_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: Build PostgreSQL With XML Support on Linux

Mateusz Loskot
On 31 May 2017 at 14:18, Osahon Oduware <[hidden email]> wrote:
> 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
> [...]
> Could someone point me to what I am doing wrong.

Asking wrong list, for the starter.
Your question belongs to https://www.postgresql.org/list/pgsql-general/

And, forgetting netiquette and copying the same post to postgis-devel
which topic [1] says:
"is devoted to discussion of ongoing development to the PostGIS"

[1] https://lists.osgeo.org/mailman/listinfo/postgis-devel

Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net
_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: Build PostgreSQL With XML Support on Linux

Osahon Oduware
Noted. Thanks. I don't seem to get much help from pgsql-general group.

On Wed, May 31, 2017 at 1:39 PM, Mateusz Loskot <[hidden email]> wrote:
On 31 May 2017 at 14:18, Osahon Oduware <[hidden email]> wrote:
> 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
> [...]
> Could someone point me to what I am doing wrong.

Asking wrong list, for the starter.
Your question belongs to https://www.postgresql.org/list/pgsql-general/

And, forgetting netiquette and copying the same post to postgis-devel
which topic [1] says:
"is devoted to discussion of ongoing development to the PostGIS"

[1] https://lists.osgeo.org/mailman/listinfo/postgis-devel

Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net
_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: Build PostgreSQL With XML Support on Linux

Mateusz Loskot
On 31 May 2017 at 15:03, Osahon Oduware <[hidden email]> wrote:
> Noted. Thanks. I don't seem to get much help from pgsql-general group.

May be try on IRC channel(s)
https://www.postgresql.org/community/irc/


Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net
_______________________________________________
postgis-users mailing list
[hidden email]
https://lists.osgeo.org/mailman/listinfo/postgis-users