On Sun, 13 Feb 2011, Aleksey Tsalolikhin wrote:

> Problem:  I can't setup replication, copy of a large table (45 GB)
> does not complete.
>
>
> Data:  Master has a 58 GB database (according to psql "\l") and over
> 45 GB is in a single table (including TOAST and indexes).
>
> Slony logs show that the COPY of other tables start and complete, but
> this 45 GB table, the COPY starts, and is still running after 11
> hours.
>

> The Slave's Slony log shows:
>
> 2011-02-13 10:37:02 PSTDEBUG2 remoteListenThread_1: queue event 1,11116 SYNC
> 2011-02-13 10:37:04 PSTDEBUG2 remoteListenThread_1: queue event 1,11117 SYNC
> 2011-02-13 10:37:06 PSTDEBUG2 remoteListenThread_1: queue event 1,11118 SYNC
> 2011-02-13 10:37:08 PSTDEBUG2 remoteListenThread_1: queue event 1,11119 SYNC
> 2011-02-13 10:37:10 PSTDEBUG2 syncThread: new sl_action_seq 1 - SYNC 4327
> 2011-02-13 10:37:12 PSTDEBUG2 localListenThread: Received event 2,4327 SYNC
> 2011-02-13 10:37:16 PSTDEBUG2 remoteListenThread_1: queue event 1,11120 SYNC
> 2011-02-13 10:37:18 PSTDEBUG2 remoteListenThread_1: queue event 1,11121 SYNC
> 2011-02-13 10:37:20 PSTDEBUG2 syncThread: new sl_action_seq 1 - SYNC 4328
> 2011-02-13 10:37:24 PSTDEBUG2 localListenThread: Received event 2,4328 SYNC

I suspect the COPY is failing at some point and then restarting.  Can you 
find the error in your slony log on the slave?  The snippet above is too 
small, it doesn't show the remoteWorker doing anything.  The 
remoteWorkerThread_1 is what is doing the copy.

As to your disk space issue, do you know which tables are using the space?

> The Slony server is not breaking a sweat (according to vmstat) - CPU
> is 95% idle.
>
> Any suggestions?
>
> Best,
> -at
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>