On Wed, 2009-01-14 at 14:39 -0600, Steven Graham wrote:
> 
> Thanks David. I had thought of some general solutions like you
> mentioned, just wondering if it could be done with slony out of the
> box. Thanks again.

Check out https://developer.skype.com/SkypeGarage/DbProjects/SkyTools
(and especially it's pgQ part), which uses similar mechanics to Slony
but allows finer control of what is done .

> -Steve
> 
> David Rees wrote: 
> > On Wed, Jan 14, 2009 at 12:31 PM, Steven Graham
> > <steven at maxpointinteractive.com> wrote:
> >   
> > > Does anyone know if there is a general config option to replicate only
> > > inserts?
> > >     
> > 
> > No, you have to replicate an entire table.
> > 
> >   
> > > I have a scenario where I want to replicated data for some analytics and I
> > > want that data to persist longer than it does on the master table. Can this
> > > be done easily, or has anyone tried?
> > >     
> > 
> > You could do this by creating a trigger on the master table which on
> > any insert, also inserts the same data into another. No slony
> > required.
> > 
> > -Dave
> > 
> > 
> >   
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
-- 
------------------------------------------
Hannu Krosing   http://www.2ndQuadrant.com
PostgreSQL Scalability and Availability 
   Services, Consulting and Training