On 22/02/2012 12:05, Ger Timmens wrote:
> Hi,
> 
> We are currently using slony 2.1.1/postgresql 9.1.2.
> 
> We were wondering if it will be possible  in future versions of slony to
> replicate
> depending on the contents of some fields in a table record.
> So in our current implemenation we have
> 
> table SomeTable ( name varchar, ......);
> 
> on the master. This table is succesfully replicated to several slaves
> (slave1, slave2, ......).
> 
> What we would like is depending on the value of 'name', replicate the
> record,
> to e.g.
> 
> slave1 if (name like 'a%'),
> slave2 if (name like 'b%),
> 
> etc...
> 
> Are there any thoughts for slony being capable of doing this ?
> How can we help developing this ? Are there other replication solutions
> that are capable of doing this ?

Just wondering if you could do this by partitioning first, and then
using Slony to replicate the partitions?

Ray.


-- 
Raymond O'Donnell :: Galway :: Ireland
rod at iol.ie