Mon May 1 03:45:59 PDT 2006
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
hai, am in postgresql replicaiton, ofcourse using Slony1.1.5. Now am in the mid of installation. While installing(localhost) i got pgbench and pgbenchslave databases as one contains data(master) and another with empty(pgbenchslva). The question is On $MASTERHOST the command to start the replication engine is slon $CLUSTERNAME "dbname=$MASTERDBNAME user=$REPLICATIONUSER host=$MASTERHOST iam getting ... slon $CLUSTERNAME "dbname=$MASTERDBNAME user=$MASTERDBA host=$MASTERHOST port=$MASTERPORT" 2006-05-01 11:24:20 IST CONFIG main: slon version 1.1.5 starting up 2006-05-01 11:24:20 IST CONFIG main: local node id = 1 2006-05-01 11:24:20 IST CONFIG main: launching sched_start_mainloop 2006-05-01 11:24:20 IST CONFIG main: loading current cluster configuration 2006-05-01 11:24:20 IST CONFIG storeNode: no_id=2 no_comment='Slave node' 2006-05-01 11:24:20 IST CONFIG storePath: pa_server=2 pa_client=1 pa_conninfo="dbname=pgbenchslave host=131.10.20.96 port=5432 user=postgres" pa_connretry=10 2006-05-01 11:24:20 IST CONFIG storeListen: li_origin=2 li_receiver=1 li_provider=2 2006-05-01 11:24:20 IST CONFIG storeSet: set_id=1 set_origin=1 set_comment='All pgbench tables' 2006-05-01 11:24:20 IST CONFIG main: configuration complete - starting threads 2006-05-01 11:24:20 IST DEBUG1 localListenThread: thread starts NOTICE: Slony-I: cleanup stale sl_nodelock entry for pid=7855 It lasts for 2-3 hours. Because of this, could not take the content of pgbench (M) to pgbenchslave(S), even though the scripts execute without error. Since the script is about to take the content of pgbench to pgbenchslave. Afterthat am going to take dump of the two databases to compare what exactly the replication happened. If u help me in this regard, u may be my eyeopenr. _____________________________________________________________________ Message sent using: NetMagic WebMail http://www.netmagicsolutions.com
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list