Regarding storenode in Slony

From: Neel Patel <neel(dot)patel(at)enterprisedb(dot)com>
To: Dave Page <dave(dot)page(at)enterprisedb(dot)com>, pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Regarding storenode in Slony
Date: 2013-10-14 12:51:45
Message-ID: CAMcbDBHjc9p6dH_eUv5YBdOE3=Or0YKSepzix1ECEGLD18w7sg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi,

As per the slony documentation and code "storenode" API requires below two
arguments.

*storenode(p_no_comment integer, p_no_id text)*
*
*
*
*
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

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Ashesh Vashi 2013-10-14 12:58:32 Re: Regarding storenode in Slony
Previous Message Dinesh Kumar 2013-10-14 09:13:00 Re: Patch for EDB binary path not set by default.