sivam at nexge.com sivam
Mon May 1 03:45:59 PDT 2006
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



More information about the Slony1-general mailing list