Mon Dec 17 09:13:06 PST 2007
- Previous message: [Slony1-general] will truncate mess up slony?
- Next message: [Slony1-general] Different indexes on slave
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Previous message: [Slony1-general] will truncate mess up slony?
- Next message: [Slony1-general] Different indexes on slave
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list