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

Samba saasira at gmail.com
Thu Sep 22 04:12:24 PDT 2016


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/77218405/attachment.htm>


More information about the postgres-xl-general mailing list