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
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
