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? _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
