Christopher Browne cbbrowne at ca.afilias.info
Mon Dec 17 09:13:06 PST 2007
Vivek Khera <vivek at khera.org> writes:
> On Dec 17, 2007, at 11:22 AM, Bill Moran wrote:
>
>> Personally, I would remove the table from replication, truncate it
>> on all
>> nodes then add it back in to replication.  The initial sync won't take
>> long since the table is empty.
>>
>> I doubt that's the only way possible, though.  What you are suggesting
>> _might_ be OK, but I don't know.
>
> Hmmmm....  I guess that'd work... once I finish splitting and
> replicating the partitions I can drop the table from replication and
> not worry about it :-)

I like the "drop it from replication" then "not need to worry about
TRUNCATE effects."
-- 
(format nil "~S@~S" "cbbrowne" "linuxdatabases.info")
http://cbbrowne.com/info/
There are  three kinds of people:  those who can count,  and those who
can't.


More information about the Slony1-general mailing list