Christopher Browne cbbrowne at ca.afilias.info
Tue Aug 19 12:27:01 PDT 2008
"Josh Harrison" <joshques at gmail.com> writes:
> Can Slony used for partial replication of the database? ie., can I
> only replicate parts of the tables(rows or columns) ?

There has been some talk of doing this; it would require making the
replication engine a fair bit more intelligent, which isn't a terrible
idea.

At present, the "level of granularity" that is available is to
replicate on a by-table basis.  You could, in principle, put triggers
on a subscriber to NULL out particular columns and/or add additional
columns.  But dropping out rows or columns altogether isn't possible
as things stand.
-- 
(format nil "~S@~S" "cbbrowne" "acm.org")
http://linuxfinances.info/info/finances.html
"My soul is more than matched; she's overmanned; and by a madman!
Insufferable sting, that sanity should ground arms on such a field!
But he drilled deep down, and blasted all my reason out of me! I think
I see his impious end; but feel that I must help him to it. Will I,
nill I, the ineffable thing has tied me to him; tows me with a cable I
have no knife to cut. Horrible old man!
[...] Oh, life! 'tis now that I do feel the latent horror in thee!"
--Moby Dick, Ch 38


More information about the Slony1-general mailing list