Thanks all
Josh

On Tue, Aug 19, 2008 at 3:27 PM, Christopher Browne <
cbbrowne at ca.afilias.info> wrote:

> "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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20080819/=
ad531693/attachment.htm