pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: infotodaniel@gmail.com
Subject: BUG #16271: rebuild PostgreSQL using --with-libxml
Date: Fri, 21 Feb 2020 18:34:31 +0000
Message-ID: <16271-896778c089aa036c@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      16271
Logged by:          Daniel Prince
Email address:      infotodaniel@gmail.com
PostgreSQL version: 9.5.3
Operating system:   CENT OS - 7
Description:        

Hi ,

My Production database version is PostgreSQL 9.5.3 on CENT OS 7. I have
received an error:
ERROR:  unsupported XML feature
DETAIL:  This functionality requires the server to be built with libxml
support.
HINT:  You need to rebuild PostgreSQL using --with-libxml.

Note : I want to enable XML Support to the existing database and also i want
to stay with the same version.

My existing bin and data directory is as follows: 
BIN : /pgsql/PostgreSQL/9.5.3/bin/ 
DATA: /pgdata/data
To resolve this issues i have tried like:
I have installed with new bin directory with a dummy data directory

./configure --prefix=/pgsql/PostgreSQL/953/ --with-openssl --with-libxml
make all  
make install
mkdir /pgdata/data953
/pgsql/PostgreSQL/953/bin/initdb -D /pgdata/data953/ 

Now I will rename old bin directory from "9.5.3" to "953_OLD", then
I will rename bin directory 953 to 9.5.3 and up the database with the
existing data folder "/pgdata/data"


Then i will do the following changes in the File: 

File Name : /etc/ld.so.conf
 
Line need to be add : 
/pgsql/Postgresql/9.5.3/lib
 
After added, need to run the following command:
 
sudo ldconfig

Finally I will start the database using the Following command : 

/pgsql/PostgreSQL/9.5.3/bin/pg_ctl start -D /pgdata/data 

Did i went any where wrong please advise?



Message-ID: <16271-896778c089aa036c@postgresql.org>
Permalink:  ../16271-896778c089aa036c@postgresql.org/
Also on:    postgresql.org/message-id/16271-896778c089aa036c@postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, infotodaniel@gmail.com
  Subject: Re: BUG #16271: rebuild PostgreSQL using --with-libxml
  In-Reply-To: <16271-896778c089aa036c@postgresql.org>
  References: <16271-896778c089aa036c@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox