Tue Aug 19 12:27:01 PDT 2008
- Previous message: [Slony1-general] Partial replication
- Next message: [Slony1-general] Partial replication
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
"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
- Previous message: [Slony1-general] Partial replication
- Next message: [Slony1-general] Partial replication
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list