On 14 Oct 2013 18:21, "Neel Patel" <neel(dot)patel(at)enterprisedb(dot)com> wrote:
>
> Hi,
>
> As per the slony documentation and code "storenode" API requires below
two arguments.
>
> storenode(p_no_comment integer, p_no_id text)
Have you cross checked with older version of Slony1?
>
>
> As per the pgAdmin code we are executing below SQL which is wrong.
>
> SELECT "_<cluster_name>".storeNode(99, 'AdminNode', false);
>
>
> Following are the steps ( PostgreSQL 9.2 ):
>
> 1. Go to any database and right click "New Slony I cluster ..."
>
> 2. In the dialog give following inputs.
>
> Join existing cluster --- Uncheck
> Cluster name ---- MyCluster
> Local node ---- 1 , MasterNode
> Admin node --- 99, AdminNode
> Comment ---- TestComment
>
> 3. Click "OK" button.
>
> 4. Error will come saying "function _MyCluster.storenode(integer,
unknown, boolean) does not exists".
>
> We need only two arguments to "storenode()" function.
>
> Why we are passing three arguments to the storeNode() API ? Any Specific
reason ?
>
> Thanks,
> Neel Patel
>
>
>
>
>
>
>
>
> Is there any specific reason to