Wed Dec 27 23:42:44 PST 2006
- Previous message: [Slony1-general] Postgresql 8.1 and slony 1.1.5 vs 1.2.2
- Next message: [Slony1-general] Problem in event confiramtion
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] Postgresql 8.1 and slony 1.1.5 vs 1.2.2
- Next message: [Slony1-general] Problem in event confiramtion
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list