On 6/12/2014 2:06 AM, Khangelani Gama wrote:
Was the database server restarted after the new version was built?
It was not restarted - Should I do so?
why aren't you running the version in the pgdg yum repository, which
includes XML support and a lot more.
--
john r pierce
> Was the database server restarted after the new version was built?
> It was not restarted - Should I do so?
Yes, otherwise the old binary will still be running.
Do also take note of Craig Ringer's email on this thread; in particular you
should always run the latest minor version, which is curr
On 14/06/12 18:06, Khangelani Gama wrote:
> On 14/06/12 17:23, Khangelani Gama wrote:
>> Hi all
> (...)
>> I then did the following:
>>
>> 1. We installed library 'xml2' (version >= 2.6.23) 2. ./configure
>> --with-libxml 3. gmake 4. gmake install
>>
>> I did not touch the database. They‘re ge
-Original Message-
From: Ian Barwick [mailto:i...@2ndquadrant.com]
Sent: Thursday, June 12, 2014 11:05 AM
To: Khangelani Gama; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgres 9.2.4 - rebuild PostgreSQL
using --with-libxml
On 14/06/12 17:23, Khangelani Gama wrote:
> Hi
On 14/06/12 17:23, Khangelani Gama wrote:
> Hi all
(...)
> I then did the following:
>
> 1. We installed library 'xml2' (version >= 2.6.23)
> 2. ./configure --with-libxml
> 3. gmake
> 4. gmake install
>
> I did not touch the database. They‘re getting the same error. Please advise
> if there
On 06/12/2014 04:23 PM, Khangelani Gama wrote:
> 2. ./configure --with-libxml
Check your config.log to make sure it actually found libxml.
Depending on how you installed it, it might not be found by configure
without an explicit path - a --with-libxml=/path/to/libxml/install/dir
Why aren't you
*From:* pgsql-general-ow...@postgresql.org [mailto:
pgsql-general-ow...@postgresql.org] *On Behalf Of *John R Pierce
*Sent:* Thursday, June 12, 2014 10:34 AM
*To:* pgsql-general@postgresql.org
*Subject:* Re: [GENERAL] Postgres 9.2.4 - rebuild PostgreSQL using
--with-libxml
On 6/12/2014 1:23 AM
On 6/12/2014 1:23 AM, Khangelani Gama wrote:
I then did the following:
1.We installed library 'xml2' (version >= 2.6.23)
2../configure --with-libxml
3.gmake
4.gmake install
was the previous version custom built with /no/ options ?
what OS/distribution is this on?
--
john r pierce
Hi all
I was asked by application dev to rebuild PostgreSQL with libxml because
they get the following error from the server.
WITH x(col) AS (SELECT 'ERROR_MISSING_DATA'::xml)
SELECT xpath('./status/text()', col) AS status
FROM x;
LINE 1: WITH x(col) AS (SELECT '= 2.6.23)
2. ./config
