[Slony1-general] Slony delay to replicate

[Andrew And]

 

 

 I am using Slony but some time Slony delay to do replicate. Some time Slony replicate fast but some time I need to wait 10, 20 or 45 minutes. 

 

 Master (table) and Slave (table) are in the some server Postgres but in BD different.

 

 What do I need to do?

 

 I find this logs in Master when Slony delay:

2006-09-21 05:25:20 BRT DEBUG2 localListenThread: Received event 1,7248 SYNC
2006-09-21 05:25:20 BRT DEBUG2 remoteWorkerThread_2: forward confirm 1,7248 received by 2
2006-09-21 05:25:26 BRT DEBUG2 remoteListenThread_2: queue event 2,7143 SYNC
2006-09-21 05:25:26 BRT DEBUG2 remoteWorkerThread_2: Received event 2,7143 SYNC
2006-09-21 05:25:26 BRT DEBUG2 remoteWorkerThread_2: SYNC 7143 processing
2006-09-21 05:25:26 BRT DEBUG2 remoteWorkerThread_2: no sets need syncing for this event
2006-09-21 05:25:32 BRT DEBUG2 syncThread: new sl_action_seq 38 - SYNC 7249
2006-09-21 05:25:32 BRT DEBUG2 localListenThread: Received event 1,7249 SYNC
2006-09-21 05:25:32 BRT DEBUG2 remoteWorkerThread_2: forward confirm 1,7249 received by 2
2006-09-21 05:25:37 BRT DEBUG2 remoteListenThread_2: queue event 2,7144 SYNC
2006-09-21 05:25:37 BRT DEBUG2 remoteWorkerThread_2: Received event 2,7144 SYNC
2006-09-21 05:25:37 BRT DEBUG2 remoteWorkerThread_2: SYNC 7144 processing
2006-09-21 05:25:37 BRT DEBUG2 remoteWorkerThread_2: no sets need syncing for this event
 

_______________________________________________
Slony1-general mailing list
Slony1-general@gborg.postgresql.org
http://gborg.postgresql.org/mailman/listinfo/slony1-general