On 5/21/07, Christopher Browne <[EMAIL PROTECTED]> wrote:
Kevin Kempter <[EMAIL PROTECTED]> writes: > Just curious - can SLONY perform the following? > > 1) replication of specified columns within a table (i.e. we don't want to > replicate the entire table per columns) ? > > 2) replication based on a where condition (i.e. we want to replicate a subset > of the data based on where clauses for each table) ? No, neither of these things has been implemented. Something somewhat like these things ought to be possible, but you might have better results by replicating the tables, and then accomplishing the restrictions via a view.
PostgreSQL supports table partitioning. Slony replicates tables. Partition your table based on the where condition and then replicate only the appropriate child table. To replicate only specified columns, consider a materialized view. However be aware that you will pay a non-trivial price on the origin system. Andrew
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
