Andrew And andcop2006
Thu Sep 21 01:47:50 PDT 2006
 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20060921/77986f3e/attachment.html 



More information about the Slony1-general mailing list