Ashish Karalkar ashish_karalkar
Wed Dec 27 23:42:44 PST 2006
Hello All,
I am replicating simple mastr slave database.following
is the database configuration script:

#!/bin/sh

CLUSTER=cluqsweb
DB1=qsweb
DB2=qswebslave
PREAMBLE="cluster name = $CLUSTER;
node 1 admin conninfo = 'dbname=qsweb
host=172.18.5.141 user=postgres password = postgres';
node 2 admin conninfo = 'dbname=qswebslave
host=172.18.5.155 user=postgres  password= postgres';
"
origin=1
subscriber=2
mainset=1

/usr/local/pgsql/bin/slonik <<_EOF_
$PREAMBLE
init cluster (id = 1, comment ='Master Node 1');
create set (id = $mainset, origin = $origin,comment =
'Set $mainset - all qsweb tables');
set add table (set id = $mainset, origin = $origin,
id=1,fully qualified name
='public.admin_owner',comment=' admin_owner');
# waiting for event	 
WAIT FOR EVENT (ORIGIN = ALL,CONFIRMED=ALL,WAIT ON=1);
echo 'ADD TABLE COMPLETE';

store node (id = 2, comment ='Slave Node 1');
WAIT FOR EVENT (ORIGIN = ALL,CONFIRMED=ALL,WAIT ON=1);
echo 'STORE SLAVE NODE COMPLETE'

store path (server = 1, client = 2,
  conninfo ='dbname=qsweb host=172.18.5.141
user=postgres password = postgres');
WAIT FOR EVENT (ORIGIN = ALL,CONFIRMED=ALL,WAIT ON=1);
echo 'STORE MASTER PATH COMPLETE ';

store path (server = 2, client = 1,
 conninfo ='dbname=qswebslave host=172.18.5.155
user=postgres password = postgres');
WAIT FOR EVENT (ORIGIN = ALL,CONFIRMED=ALL,WAIT ON=1);
echo ' STORE SLAVE PATH COMPLETE';

store listen (origin = 1, provider = 1, receiver = 2);
WAIT FOR EVENT (ORIGIN = ALL,CONFIRMED=ALL,WAIT ON=1);

echo 'STORE LISTEN COMPLETE 1';
store listen (origin = 2, provider = 2, receiver = 1);
WAIT FOR EVENT (ORIGIN = ALL,CONFIRMED=ALL,WAIT ON=1);
echo 'STORE LISTEN COMPLETE 2';
	 
_EOF_

The echo command for "ADD TABLE COMPLETE" is displayed
but then no new event confirmation takes place.
and atlast i get following massage
<stdin>:74: timeout exceeded while waiting for event
confirmation

can anybody please suggest me where I am wrong

With Regards
Ashish...

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 



More information about the Slony1-general mailing list