On 9/21/2004 5:09 AM, hannu at skype.net wrote:

>>>> I can't find any doc's on what happens to replication data collected by
>>>> triggers -
>>>>
>>>> 1) when will it be deleted (both on master and on replicating slaves)
>>>> 2) in what cases is it kept on slave side
>>>
>>> Loosely speaking, it is deleted until it is not needed anymore by any of
>>> the subscribers for a given node.
>>
>> So there will be relatively little overhead little overhead if I SUBSCRIBE
>> SET with FORWARD=YES even if not planning to start replicating from it
>> immediately ?
> 
> And another thing - is it possible to change FORWARD state later ?

yes, you just issue another "subscribe" again. Subscribing an already 
subscribed set just causes the provider and forward settings to be 
overwritten without the need to copy the data again.


Jan

> 
> -----------
> Hannu
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general


-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #