Slave log:

2011-11-30 15:01:19 UTCINFO   remoteWorkerThread_1: syncing set 1 with 6 table
(s) from provider 1

2011-11-30 15:01:19 UTCINFO   remoteWorkerThread_1: SYNC 5000053227 done in 
0.004 seconds

2011-11-30 15:01:20 UTCERROR  remoteListenThread_1: "select ev_origin, 
ev_seqno, ev_timestamp,        ev_snapshot,        "pg_catalog".
txid_snapshot_xmin(ev_snapshot),        "pg_catalog".txid_snapshot_xmax
(ev_snapshot),        ev_type,        ev_data1, ev_data2,        ev_data3, 
ev_data4,        ev_data5, ev_data6,        ev_data7, ev_data8 from 
"_sql_cluster_grade1".sl_event e where (e.ev_origin = '1' and e.ev_seqno > 
'5000053227') order by e.ev_origin, e.ev_seqno limit 40" - FATAL:  terminating 
connection due to administrator command

2011-11-30 15:01:20 UTCERROR  remoteListenThread_1: "select con_origin, 
con_received,     max(con_seqno) as con_seqno,     max(con_timestamp) as 
con_timestamp from "_sql_cluster_grade1".sl_confirm where con_received <> 2 
group by con_origin, con_received" 2011-11-30 15:01:22 UTCERROR  
remoteListenThread_1: "select ev_origin, ev_seqno, ev_timestamp,        
ev_snapshot,        "pg_catalog".txid_snapshot_xmin(ev_snapshot),        
"pg_catalog".txid_snapshot_xmax(ev_snapshot),        ev_type,        ev_data1, 
ev_data2,        ev_data3, ev_data4,        ev_data5, ev_data6,        
ev_data7, ev_data8 from "_sql_cluster_grade1".sl_event e where (e.ev_origin = 
'1' and e.ev_seqno > '5000053227') order by e.ev_origin, e.ev_seqno limit 40" - 
no connection to the server

2011-11-30 15:01:22 UTCERROR  remoteListenThread_1: "select con_origin, 
con_received,     max(con_seqno) as con_seqno,     max(con_timestamp) as 
con_timestamp from "_sql_cluster_grade1".sl_confirm where con_received <> 2 
group by con_origin, con_received" 2011-11-30 15:01:24 UTCERROR  
remoteListenThread_1: "select ev_origin, ev_seqno, ev_timestamp,        
ev_snapshot,        "pg_catalog".txid_snapshot_xmin(ev_snapshot),        
"pg_catalog".txid_snapshot_xmax(ev_snapshot),        ev_type,        ev_data1, 
ev_data2,        ev_data3, ev_data4,        ev_data5, ev_data6,        
ev_data7, ev_data8 from "_sql_cluster_grade1".sl_event e where (e.ev_origin = 
'1' and e.ev_seqno > '5000053227') order by e.ev_origin, e.ev_seqno limit 40" - 
no connection to the server

 

Please let me know how I can sync again the server without loose data and 
restart the replica from the beginning.

 

Thank you,

 
Francesco Boccacci