[Postgres-xl-developers] Fwd: fix postgres-xl build on FreeBSD

Jov amutu at amutu.com
Wed Dec 10 02:24:35 PST 2014


let's talk on the list.

Jov
blog: http:amutu.com/blog <http://amutu.com/blog>

---------- Forwarded message ----------
From: Jov <amutu at amutu.com>
Date: 2014-12-10 18:22 GMT+08:00
Subject: Re: [Postgres-xl-developers] fix postgres-xl build on FreeBSD
To: Ramanuj Hari <hari.ramanuj at gmail.com>


have you test with the patch above?I install pgxl with pgxc_ctl.
I run PG-XL on FreeBSD with some more patch.The patch above can only make
pgxc_ctl install and init cluster,but when you run SQL,there will be
problem.I have solve the problem,and wait for the above patch accepting and
then will submit the other patch.

for install and init pgxl,there are 2 problems for FreeBSD user to solve:
1.install the bash shell and apply the above patch.
2.set remote env for ssh.you should add a file named environment in the ~/.ssh
dir with PATH set to pgxl bin dir.

Jov
blog: http:amutu.com/blog <http://amutu.com/blog>

2014-12-10 17:56 GMT+08:00 Ramanuj Hari <hari.ramanuj at gmail.com>:

> Hi Jov,
>
> I am also trying to run on FreeBSD r10. But got into issue.
>
> ----
> do_shell.c:dump_cmdList(713) *** cmdList Dump
> *******************************
> allocated = 2, used = 1
> do_shell.c:dump_cmdList(723) === CMD: 0 ===
> do_shell.c:dump_cmdList(727)    --- CMD-EL: 0:host="NULL", command="psql
> -p 11921 -h 10.102.103.135 -a postgres pgxl",
> localStdin="/tmp/STDIN_48989_34", localStdout="NULL"
> EXECUTE DIRECT ON (datanode1) 'CREATE NODE coord1 WITH
> (TYPE=''coordinator'', HOST=''10.102.103.135'', PORT=11921)';
> EXECUTE DIRECT ON (datanode1) 'ALTER NODE datanode1 WITH
> (TYPE=''datanode'', HOST=''10.102.103.135'', PORT=12921, PRIMARY,
> PREFERRED)';
> EXECUTE DIRECT ON (datanode1) 'SELECT pgxc_pool_reload()';
> do_shell.c:dump_cmdList(737)    ----------
> do_shell.c:doCmdEl(360) Local command: "psql -p 11921 -h 10.102.103.135 -a
> postgres pgxl", actual: "( psql -p 11921 -h 10.102.103.135 -a postgres pgxl
> ) > /tmp/STDOUT_48989_35 2>&1 < /tmp/STDIN_48989_34"
> EXECUTE DIRECT ON (datanode1) 'CREATE NODE coord1 WITH
> (TYPE=''coordinator'', HOST=''10.102.103.135'', PORT=11921)';
> ERROR:  Could not begin transaction on Datanodes
> EXECUTE DIRECT ON (datanode1) 'ALTER NODE datanode1 WITH
> (TYPE=''datanode'', HOST=''10.102.103.135'', PORT=12921, PRIMARY,
> PREFERRED)';
> ERROR:  Could not begin transaction on Datanodes
> EXECUTE DIRECT ON (datanode1) 'SELECT pgxc_pool_reload()';
> ERROR:  Could not begin transaction on data node.
> coord_cmd.c:configure_datanodes(416) Done.
> PGXC$
> -----
>
> Could you please help how did you try, whether it is pgxc_ctl or manual
> configuration.
>
> Thanks,
> Ramanuj
>
>
> On Wed, Oct 15, 2014 at 7:21 AM, Jov <amutu at amutu.com> wrote:
>
>> v2 change:
>> replace "#!/bin/bash" with "#!/usr/bin/env bash" in these files:
>> contrib/pgxc_ctl/pgxc_ctl.bash
>> contrib/pgxc_ctl/pgxc_ctl_bash.c
>> contrib/pgxc_ctl/pgxc_ctl_bash.org
>> contrib/pgxc_ctl/pgxc_ctl_bash_2
>> contrib/pgxc_ctl/pgxc_ctl_conf_part
>>
>> I am success to setup and init pgxl cluster after this patch on FreeBSD
>> r10 amd64
>>
>> Jov
>> blog: http:amutu.com/blog <http://amutu.com/blog>
>>
>> 2014-10-15 5:52 GMT+08:00 Jov <amutu at amutu.com>:
>>
>>> Thanks.I find some runtime problem when running pgxc_ctl,I will submit a
>>> updated patch later.
>>> 2014年10月15日 4:52 AM于 "Mason Sharp" <msharp at translattice.com>写道:
>>>
>>> Hi Jov,
>>>>
>>>> Will try to take a closer look soon.
>>>>
>>>> Thanks,
>>>>
>>>> Mason
>>>>
>>>> On Mon, Oct 13, 2014 at 2:50 AM, Jov <amutu at amutu.com> wrote:
>>>>
>>>>> any idea?
>>>>>
>>>>> Jov
>>>>> blog: http:amutu.com/blog <http://amutu.com/blog>
>>>>>
>>>>> 2014-10-11 17:41 GMT+08:00 赵伟 <amutu at amutu.com>:
>>>>>
>>>>>> when build pgxl on FreeBSD,there are 3 problems:
>>>>>> 1."WEXITSTATUS(status) " macro can't be resolve when compile
>>>>>> src/gtm/gtm_ctl/gtm_ctl.c ,caused by lacking of sys/wait.h header.
>>>>>>
>>>>>> 2.type "pid_t" undefined when compile contrib/pgxc_ctl/utils.h,caused
>>>>>> by lacking of sys/types.h header
>>>>>>
>>>>>> 3.contrib/pgxc_ctl/make_signature bash can't be running bacause of it
>>>>>> think the bash is installed at /bin/bash,which is not true on
>>>>>> FreeBSD.replace with "#!/usr/bin/env bash" solve the problem.
>>>>>>
>>>>>> patch attached.
>>>>>>
>>>>>> thanks,
>>>>>> Jov
>>>>>>
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------------
>>>>>> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
>>>>>> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS
>>>>>> Reports
>>>>>> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
>>>>>> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>>>>>> http://p.sf.net/sfu/Zoho
>>>>>> _______________________________________________
>>>>>> Postgres-xl-developers mailing list
>>>>>> Postgres-xl-developers at lists.sourceforge.net
>>>>>> https://lists.sourceforge.net/lists/listinfo/postgres-xl-developers
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------
>>>>> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
>>>>> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS
>>>>> Reports
>>>>> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
>>>>> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
>>>>> http://p.sf.net/sfu/Zoho
>>>>> _______________________________________________
>>>>> Postgres-xl-developers mailing list
>>>>> Postgres-xl-developers at lists.sourceforge.net
>>>>> https://lists.sourceforge.net/lists/listinfo/postgres-xl-developers
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Mason Sharp
>>>>
>>>> TransLattice - http://www.translattice.com
>>>> Clustered and Distributed Database Solutions
>>>>
>>>>
>>>>
>>
>>
>> ------------------------------------------------------------------------------
>> Comprehensive Server Monitoring with Site24x7.
>> Monitor 10 servers for $9/Month.
>> Get alerted through email, SMS, voice calls or mobile push notifications.
>> Take corrective actions from your mobile device.
>> http://p.sf.net/sfu/Zoho
>> _______________________________________________
>> Postgres-xl-developers mailing list
>> Postgres-xl-developers at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/postgres-xl-developers
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-developers-postgres-xl.org/attachments/20141210/05e36d9b/attachment.htm>


More information about the Postgres-xl-developers mailing list