Preconfigured Postgresql database and libxml

[sjoerd.jump]

Hello,

I was exploring some xml-import options for one of my reports, but when using phpPgAdmin to administer my database I run into the following error:

DETAIL:  This functionality requires the server to be built with libxml support.

HINT:  You need to rebuild PostgreSQL using --with-libxml.

 

Problem is; I can't find the ./configure file for postgresql since it was preinstalled with Jasperserver...

Would any of you know how to install the libxml package?

Thanks!

[sjoerd.jump]

This is what i want to add :

 

INSERT INTO beers (data) values ('HarpoonBoston, USA');

 

This is the systems response

ERROR: unsupported XML feature

LINE 1: INSERT INTO beers (data) values ('Harpoon...

^

DETAIL: This functionality requires the server to be built with libxml support.

HINT: You need to rebuild PostgreSQL using --with-libxml.

[sjoerd.jump]

Oke, I managed to find the solution..

Verify your postgresql installation (mine is 9.0.4.)

Download the same installation version from here

Extraxt files to $JASPERSERVER/postgresql/

$JASPERSERVER/ctlscript.sh stop

Install as per instruction of postgresql

I wasn't too sure about the confifure option (when to do it, so i used the following command before and after installation) ./configure -prefix=/opt/jasperserver/postgresql/ --with-libxml

$JASPERSERVER/ctlscript.sh start

[tkavanagh]

Nice work!