| 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: | Whole Thread | Raw Message | 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
| 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. |