Hello All, 
I am having PG 8.2 on linux.
after configuring and running slon process no data is
copied.
slon process runs on both the machine but no data is
copied.
Here is my configuration file:

#!/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');
set add table (set id = $mainset, origin = $origin,
id=2,fully qualified name
='public.admin_school',comment=' admin_school');
set add table (set id = $mainset, origin = $origin,
id=3,fully qualified name
='public.admin_session',comment=' admin_session');
set add table (set id = $mainset, origin = $origin,
id=4,fully qualified name
='public.admin_society',comment=' admin_society');
set add table (set id = $mainset, origin = $origin,
id=5,fully qualified name
='public.admin_society_detail',comment='
admin_society_detail');
set add table (set id = $mainset, origin = $origin,
id=6,fully qualified name
='public.core_board',comment=' core_board');
set add table (set id = $mainset, origin = $origin,
id=7,fully qualified name
='public.core_caste',comment=' core_caste');
set add table (set id = $mainset, origin = $origin,
id=8,fully qualified name
='public.core_certificate',comment='
core_certificate');
set add table (set id = $mainset, origin = $origin,
id=9,fully qualified name
='public.core_city',comment=' core_city');
set add table (set id = $mainset, origin = $origin,
id=10,fully qualified name
='public.core_class',comment=' core_class');

# waiting for event	 
	 
	WAIT FOR EVENT (
 		 ORIGIN = ALL,

   CONFIRMED = ALL,
   WAIT ON = 1
);




store node (id = 2, comment ='Slave Node 1');
store path (server = 1, client = 2,
  conninfo ='dbname=qsweb host=172.18.5.141
user=postgres password = postgres');
store path (server = 2, client = 1,
 conninfo ='dbname=qswebslave host=172.18.5.155
user=postgres password = postgres');
store listen (origin = 1, provider = 1, receiver = 2);
store listen (origin = 2, provider = 2, receiver = 1);


_EOF_

NOW THE SUBSCRIPTION IS DONE :
/usr/local/pgsql/bin/slonik <<_EOF_
	 # ----
	 # This defines which namespace the replication
system uses
	 # ----
	 cluster name = cluqsweb;

	 # ----
	 # Admin conninfo's are used by the slonik program to
connect
	 # to the node databases.  So these are the
PQconnectdb arguments
	 # that connect from the administrators workstation
(where
	 # slonik is executed).
	 # ----
	 node 1 admin conninfo = 'dbname=qsweb
host=172.18.5.141 user=postgres';
	 node 2 admin conninfo = 'dbname=qswebslave
host=172.18.5.155 user=postgres';

	 # ----
	 # Node 2 subscribes set 1
	 # ----
	 subscribe set ( id = 1, provider = 1, receiver = 2,
forward = yes);
_EOF_


AFTER RUNNING THE THE SLON PROCESS GIVE FOLLOWING
MASSAGE:

2006-12-12 14:56:00 IST DEBUG1 copy_set 1
2006-12-12 14:56:00 IST DEBUG4 version for
"dbname=qsweb host=172.18.5.141 user=postgres password
= postgres" is 80200
2006-12-12 14:56:00 IST DEBUG1 remoteWorkerThread_1:
connected to provider DB
2006-12-12 14:56:00 IST WARN   remoteWorkerThread_1:
transactions earlier than XID 24697 are still in
progress
2006-12-12 14:56:00 IST WARN   remoteWorkerThread_1:
data copy for set 1 failed - sleep 60 seconds


Please help 

With Regards
Ashish Karalkar


 
____________________________________________________________________________________
Need a quick answer? Get one in minutes from people who know.
Ask your question on www.Answers.yahoo.com