In response to Geoffrey <[EMAIL PROTECTED]>:

> I don't remember seeing these messages before, maybe I'm wrong. 
> Question is, the node 2 database I'm replicating to, is already empty. 
> Does slony simply try a wholesale truncation of all replicated tables 
> anyway?

Yes.  Slony doesn't trust the user to have a properly cleaned out
database, which (IMHO) is A Good Thing.

> Also, I see a couple messages like these:
> 
> truncate of "public"."foo" failed - doing delete
> 
> I don't understand why the truncation would fail.

>From the PostgreSQL docs:
RESTRICT

    Refuse to truncate if any of the tables have foreign-key references from 
tables that are not to be truncated. This is the default. 


-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

[EMAIL PROTECTED]
Phone: 412-422-3463x4023
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general

Reply via email to