Jeff Amiel jamiel
Fri Jan 19 09:22:05 PST 2007
Brad Nicholson wrote:
> What you want to do is:
>
> -Forget about restoring the data on the subscriber (unless it contains
> stuff that isn't replicated that you need).
> -extract the schema only (no data) from the master database.
> -restore that on the subscriber
> -add the node back to replication and subscribe it.
>
>   

ok...I did so...fairly painless so far.
now getting interesting warnings (no replication appears to be 
occurring) on the new node

WARN   remoteWorkerThread_1: transactions earlier than XID 2148952995 
are still in progress
WARN   remoteWorkerThread_1: data copy for set 1 failed - sleep 15 seconds
WARN   remoteWorkerThread_1: transactions earlier than XID 2148952995 
are still in progress
WARN   remoteWorkerThread_1: data copy for set 1 failed - sleep 30 seconds
WARN   remoteWorkerThread_1: transactions earlier than XID 2148952995 
are still in progress
WARN   remoteWorkerThread_1: data copy for set 1 failed - sleep 60 seconds

Any thoughts?



More information about the Slony1-general mailing list