Rebuilding PostgreSQL with LIBXML support

[Anthro]

Hi there all, hope some of the Linux gurus have some advice here

I recently became involved in a project where the server runs OpenSUSE and PostgreSQL 9.3
When performing an action in the application that uses PostgreSQL it states

unsupported XML feature
This functionality requires the server to be built with libxml support

Now I have read a few places that I will need to "rebuild" the server to actually include this library..
Anyone ever done this before, and can maybe hand out some pointers ??
General FAQ does not say much, and I have struggled *brain dead*
Would I need to reinstall from scratch or can I simply include these files via a command line / bash script ?

 

[Nod]

The basics are here: http://www.postgresql.org/docs/9.2/static/install-procedure.html
You have to download the source for Postgresql.
The libxml-devel package must also be installed.
The description of the "--with-libxml" option:

--with-libxml

    Build with libxml (enables SQL/XML support). Libxml version 2.6.23 or later is required for this feature.

    Libxml installs a program xml2-config that can be used to detect the required compiler and linker options. PostgreSQL will use it automatically if found. To specify a libxml installation at an unusual location, you can either set the environment variable XML2_CONFIG to point to the xml2-config program belonging to the installation, or use the options --with-includes and --with-libraries.

Read the documentation for the Postgresql version you which to compile. It is generally a good source of information.
The "configure" script will also tell you what it needs, and can be re-run again after you install new dependencies.

 

[Anthro]

The basics are here: http://www.postgresql.org/docs/9.2/static/install-procedure.html
You have to download the source for Postgresql.
The libxml-devel package must also be installed.
The description of the "--with-libxml" option:

--with-libxml

    Build with libxml (enables SQL/XML support). Libxml version 2.6.23 or later is required for this feature.

    Libxml installs a program xml2-config that can be used to detect the required compiler and linker options. PostgreSQL will use it automatically if found. To specify a libxml installation at an unusual location, you can either set the environment variable XML2_CONFIG to point to the xml2-config program belonging to the installation, or use the options --with-includes and --with-libraries.

Read the documentation for the Postgresql version you which to compile. It is generally a good source of information.
The "configure" script will also tell you what it needs, and can be re-run again after you install new dependencies.

Any way, in your opinion that I can get a distribution of PostgreSQL with this LIBXML already included ?
As I know the instructions to reinstall from scratch (and prepared to do so) - would need to be for OpenSUSE 12.3 ^

 

[Nod]

I did a quick search but could not find anything. It might be available from some custom repo, but it should be quicker to just compile it. You can create a RPM after compilation for future use.