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