Re: [Postgres-xc-general] Question about XML support in Postgres-XC

[Roumalyn T. <rt...@nt...>]

Ok, I understand now.
Thank you very much!



On Mon, 19 Nov 2012 13:41:00 +0900, Michael Paquier
<mic...@gm...> wrote:
> On Mon, Nov 19, 2012 at 1:33 PM, Roumalyn Tiru <rt...@nt...>
> wrote:
> 
>> Hi!
>>
>> Sorry for the confusion. This is still related to the problem I posted
>> about the XML data type.
>>
>> Previously, I started the servers using pg_ctl commands:
>> gtm_ctl -Z gtm -D /usr/local/pgsql/data_gtm start
>> pg_ctl start -D /usr/local/pgsql/data_datanode1 -Z datanode
>> pg_ctl start -D /usr/local/pgsql/data_datanode2 -Z datanode
>> pg_ctl start -D /usr/local/pgsql/data_coordinator1 -Z coordinator
>>
>> Then, I execute INSERT statements for a table with XML data type:
>> CREATE TABLE test (y int, x xml);
>> INSERT INTO test VALUES (1, '<foo>abc</foo>');
>>
>> Then, I get the error:
>> ERROR:  unsupported XML feature
>>
>> When I read this message, I tried to change the way I started the
>> servers:
>> >>The error message is clear, the binary "postgres" you are using to
>> launch your nodes has not been compiled with libxml.
>> >>You would get the same error with vanilla postgres.
>>
>> I used postgres directly to start the servers.
>> /usr/local/pgsql/bin/gtm -D /usr/local/pgsql/data_gtm 1>&1 &
>> /usr/local/pgsql/bin/postgres -X -p 15432 -D
>> /usr/local/pgsql/data_datanode1 1>&1 &
>> /usr/local/pgsql/bin/postgres -X -p 15433 -D
>> /usr/local/pgsql/data_datanode2 1>&1 &
>> /usr/local/pgsql/bin/postgres -C -D /usr/local/pgsql/data_coordinator1
>> 1>&1 &
>>
>> When I executed the INSERT statement again, it was successful.
>>
>> Does using pg_ctl instead of postgres have any limitation?
>>
> The only problem I see is related to your environment.
> I believe that pg_ctl is trying to kick a binary postgres that has NOT
been
> compiled with --libxml at configuration.
> 
> So, please check the following:
> 1) What is the output of this command which postgres
> If the result is NOT /usr/local/pgsql/bin/, it means that pg_ctl is
trying
> to kick a different binary, which has not been compiled with --libxml
> 2) Try to launch pg_ctl once again and add this option => -p
> /usr/local/pgsql/bin/
> This will enforce pg_ctl to launch the binary postgres in given
directory.
> 
> Once again, you would obtain the same problems with vanilla postgres.
This
> is not related to XC at all but with the way you install and manage your
> binaries in your environment.