On 5/21/07, Christopher Browne <cbbrowne at ca.afilias.info> wrote:
>
> Kevin Kempter <kevin at kevinkempterllc.com> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070529/=
d3ea4832/attachment.htm