On 10/14/2005 4:30 PM, Ujwal S. Setlur wrote:

> 
> --- Andrew Sullivan <ajs at crankycanuck.ca> wrote:
> 
>> On Fri, Oct 14, 2005 at 01:15:29PM -0700, Ujwal S.
>> Setlur wrote:
>> > How can I find out whether the subscription
>> process
>> > has started?
>> 
>> ps. I expect.  The subscription causes the source
>> table to be COPY'd
>> to the subscriber, so if it's large, it takes quite
>> a while.  And
>> yes, you won't see anything, because it all happens
>> in one
>> transaction.
>> 
>> A
>> 
> 
> What about other tables that are not large? Are all
> the tables done in one transaction?

The entire subscription of the whole set happens in one single giant 
transaction. The only thing you could see is your disk space being 
allocated and of course a lot of network activity.

Does the slon log on the subscriber say that it has started to copy the set?


Jan

> 
> Thanks,
> 
> Ujwal
> _______________________________________________
> 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 #