<div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>Help me please.....</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>my slony-I 1.2.9</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>postgre8.2.4</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>i've installed pgbench and plpgsql</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>I've make setup.sh like this, but there error messages like under this??</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>#!/bin/sh</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>CLUSTER=test1</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman"
size=3>MASTERDBNAME=pgbench_node1</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>SLAVEDBNAME=pgbench_node2</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>MASTERHOST=localhost</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>SLAVEHOST=localhost</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>SLONY_USER=postgres</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>PGBENCH_USER=postgres</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>/usr/local/pgsql/bin/slonik <<_EOF_</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>cluster name = $CLUSTER;</FONT></FONT></div>
<div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST user=$SLONY_USER';</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST user=$SLONY_USER';</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>init cluster ( id = 1, comment = 'Node 1' );</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>table add key ( node id = 1, fully qualified name = 'public.history' );</FONT></FONT></div> <div class=MsoNormal
style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>create set ( id = 1, origin = 1, comment = 'All pgbench tables' );</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>set add table ( set id = 1, origin = 1,</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>id = 1, fully qualified name = 'public.accounts',</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>comment = 'Table accounts' );</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New
Roman"><SPAN style="mso-spacerun: yes"> </SPAN>set add table ( set id = 1, origin = 1,</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>id = 2, fully qualified name = 'public.branches',</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>comment = 'Table branches' );</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>set add table ( set id = 1, origin = 1,</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>id = 3,
fully qualified name = 'public.tellers',</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>comment = 'Table tellers' );</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>set add table ( set id = 1, origin = 1,</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>id = 4, fully qualified name = 'public.history',</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>key = serial,</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in
0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>comment = 'Table history' );</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>store node ( id = 2, comment = 'Node 2' );</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>store path ( server = 1, client = 2,</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST user=$SLONY_USER');</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN
style="mso-spacerun: yes"> </SPAN>store path ( server = 2, client = 1,</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST user=$SLONY_USER');</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>store listen ( origin = 1, provider = 1, receiver = 2 );</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>store listen ( origin = 2, provider = 2, receiver = 1 );</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>_EOF_</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in
0pt"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>there<SPAN style="mso-spacerun: yes"> </SPAN>were<SPAN style="mso-spacerun: yes"> </SPAN>error messages like this</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3><stdin>:4: Error: namespace "_test1" already exists in database of node 1</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3><stdin>:4: ERROR: no admin conninfo for node 149930256</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></div> <div class=MsoNormal style="MARGIN: 0in
0in 0pt"><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>when i make the subscribe.sh like this</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>#!/bin/sh</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>CLUSTER=test1</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>MASTERDBNAME=pgbench_node1</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>SLAVEDBNAME=pgbench_node2</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>MASTERHOST=localhost</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>SLAVEHOST=localhost</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT
face="Times New Roman" size=3>SLONY_USER=postgres</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>PGBENCH_USER=postgres</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>/usr/local/pgsql/bin/slonik <<_EOF_</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>cluster name = $CLUSTER;</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>node 1 admin conninfo = 'dbname=$MASTERDBNAME host=$MASTERHOST user=$SLONY_USER';</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST
user=$SLONY_USER';</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT size=3><FONT face="Times New Roman"><SPAN style="mso-spacerun: yes"> </SPAN>subscribe set ( id = 1, provider = 1, receiver = 2, forward = no);</FONT></FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>_EOF_</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>there were<SPAN style="mso-spacerun: yes"> </SPAN>error messages like this : </FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3><stdin>:18: PGRES_FATAL_ERROR select "_test1".subscribeSet(1, 1, 2, 'f');<SPAN style="mso-spacerun: yes"> </SPAN>- ERROR:<SPAN style="mso-spacerun: yes"> </SPAN>insert or update on table "sl_path"
violates foreign key constraint "pa_client-no_id-ref"</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>DETAIL:<SPAN style="mso-spacerun: yes"> </SPAN>Key (pa_client)=(2) is not present in table "sl_node".</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>CONTEXT:<SPAN style="mso-spacerun: yes"> </SPAN>SQL statement "INSERT INTO "_test1".sl_path (pa_server, pa_client, pa_conninfo, pa_connretry) values ( $1 ,<SPAN style="mso-spacerun: yes"> </SPAN>$2 , '<event pending>', 10)"</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>PL/pgSQL function "subscribeset_int" line 53 at SQL statement</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>SQL statement "SELECT<SPAN style="mso-spacerun: yes"> </SPAN>"_test1".subscribeSet_int( $1 ,<SPAN style="mso-spacerun:
yes"> </SPAN>$2 ,<SPAN style="mso-spacerun: yes"> </SPAN>$3 ,<SPAN style="mso-spacerun: yes"> </SPAN>$4 )"</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>PL/pgSQL function "subscribeset" line 63 at perform</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>so,what happend in my replicator?? and what should i do to solve this error</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><o:p><FONT face="Times New Roman" size=3> </FONT></o:p></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>thank kyu</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New Roman" size=3>regards,</FONT></div> <div class=MsoNormal style="MARGIN: 0in 0in 0pt"><FONT face="Times New
Roman" size=3>bayu</FONT></div><p> 
<hr size=1>TV dinner still cooling?<br><a href="http://us.rd.yahoo.com/evt=49979/*http://tv.yahoo.com/">Check out "Tonight's Picks"</a> on Yahoo! TV.