Regarding storenode in Slony
От | Neel Patel |
---|---|
Тема | Regarding storenode in Slony |
Дата | |
Msg-id | CAMcbDBHjc9p6dH_eUv5YBdOE3=Or0YKSepzix1ECEGLD18w7sg@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Regarding storenode in Slony
|
Список | 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
В списке pgadmin-hackers по дате отправления: