[Postgres-xl-general] [Contactform] Nodes not being created

Samba saasira at gmail.com
Thu Sep 22 05:19:15 PDT 2016


you are not referring to pgxl distribution, most probably you may have
another normal postgres installation on your system.

ps aux | grep postgres

would give you list of postgress running on your system. check the path of
the binaries listed in the results. i am pretty sure the path of postgres
binaries wil not be from within the pgxl distribution.

reason : you may not have added pgxl distribution's bin folder (for example
: /home/username/Downloads/postgres-xl-9.5-rc1/bin) to your PATH.

moreover, it is better if you remove your 'normal' postgresql installation
altogether to avoid unnecessary complications.

On Thu, Sep 22, 2016 at 5:06 PM, Pragun Joshi <pragun.joshi at gmail.com>
wrote:

> No I didn't copy binaries from windows. But the second thing got my
> attention. Yes, there were special characters and I revised the
> configuration and edited it.. However, my issue still persists. I mean
> following errors still repeat:
>
> ALTER NODE coord1 WITH (HOST='localhost', PORT=6100);
> ERROR:  syntax error at or near "NODE"
> LINE 1: ALTER NODE coord1 WITH (HOST='localhost', PORT=6100);
>
> SELECT pgxc_pool_reload();
> ERROR:  function pgxc_pool_reload() does not exist
> LINE 1: SELECT pgxc_pool_reload();
>
> EXECUTE DIRECT ON (dn1) 'CREATE NODE dn2 WITH (TYPE=''datanode'',
> HOST=''localhost'', PORT=6201, PREFERRED)';
> ERROR:  syntax error at or near "ON"
> LINE 1: EXECUTE DIRECT ON (dn1) 'CREATE NODE dn2 WITH (TYPE=''datano...
>
> And I'm really pissed of it... Actually its been 5 days that I've been
> trying to configure this.
>
> On Thu, Sep 22, 2016 at 4:57 PM, Samba <saasira at gmail.com> wrote:
>
>> i am also new to postgres-xl but am wildly guessing... did you copy the
>> binaries from windows to linux? if so, did you try running dos2unix over
>> them.
>>
>> also check pgxc_ctl.conf file for special characters -- have seen that
>> pgxc_ctl itself is messing this conf file on node additions & removals by
>> inserting special characters in place of zeroes, specially for
>> xxxxxxxMaxWalSenders property. so verify and if suspicious replace each of
>> those special characters with 0 (zero).
>>
>> i hope this helps,
>> Samba
>>
>> On Thu, Sep 22, 2016 at 9:53 AM, Pragun Joshi <pragun.joshi at gmail.com>
>> wrote:
>>
>>> I'd appreciate if any of your community members would reply to me ASAP!
>>>
>>> On Wed, Sep 21, 2016 at 5:11 PM, Pragun Joshi <pragun.joshi at gmail.com>
>>> wrote:
>>>
>>>>
>>>> ---------- Forwarded message ----------
>>>> From: Umair Shahid <umair.shahid at 2ndquadrant.com>
>>>> Date: Wed, Sep 21, 2016 at 5:09 PM
>>>> Subject: Re: [Contactform] Nodes not being created
>>>> To: pragun.joshi at gmail.com
>>>> Cc: info <info at 2ndquadrant.com>
>>>>
>>>>
>>>> Thank you for reaching out to 2ndQuadrant.
>>>>
>>>> For all queries related to community support and help, please send an
>>>> email to postgres-xl-general at lists.sourceforge.net. One of the
>>>> Postgres-XL community members will get back to you soon.
>>>>
>>>> - Umair
>>>>
>>>> On Wed, Sep 21, 2016 at 4:16 PM, <pragun.joshi at gmail.com> wrote:
>>>>
>>>>> Well I've been trying to configure Postgres-XL since a couple of
>>>>> days. To my view, the configuration is going fine as i followed one of your
>>>>> documentation procedures to configure using pgxc_ctl command line rather
>>>>> directly playing withe the pgxc_ctl.conf file.
>>>>>
>>>>> Now as i assume that the configuration is all okay and I issue this
>>>>> command "pgxc_ctl init all", it checks for regular stuffs and at
>>>>> last, while creating/altering nodes, there's this SYNTAX ERROR all over
>>>>> my console which reads CREATE NODE dn1 WITH (TYPE='datanode',
>>>>> HOST='localhost', PORT=6200, PREFERRED);
>>>>> ERROR:  syntax error at or near "NODE"
>>>>> LINE 1: CREATE NODE dn1 WITH (TYPE='datanode',
>>>>> HOST='localhost', POR...
>>>>> and
>>>>> EXECUTE DIRECT ON (dn1) 'ALTER NODE dn1 WITH
>>>>> (TYPE=''datanode'', HOST=''localhost'',
>>>>> PORT=6200, PREFERRED)';
>>>>> ERROR:  syntax error at or near "ON"
>>>>> LINE 1: EXECUTE DIRECT ON (dn1) 'ALTER NODE dn1 WITH
>>>>> (TYPE=''datanod...
>>>>> with other repeating errors of similar type.
>>>>>
>>>>> I'd be really grateful if somebody would get me out of this
>>>>> trouble. This has actually started to be kind of a headache to me now.
>>>>>
>>>>> Thanks in advance! Do reply soon...
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Umair Shahid
>>>> 2ndQuadrant - The PostgreSQL Support Company
>>>> http://www.2ndQuadrant.com/
>>>>
>>>>
>>>
>>> ------------------------------------------------------------
>>> ------------------
>>>
>>> _______________________________________________
>>> Postgres-xl-general mailing list
>>> Postgres-xl-general at lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/postgres-xl-general
>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20160922/57032ef1/attachment.htm>


More information about the postgres-xl-general mailing list