--- Jan Wieck <JanWieck at Yahoo.com> wrote:

> 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?
> 


OK, I think it just got done. Took about 4 hours. The
large table has close to 30 million rows.

I was checking for network activity using netstat -a,
but did not really see much. Maybe I was looking for
the wrong things. I was also checking the sl_log_1 and
sl_log_2 tables on the subscriber, but they were
empty.

Thanks,

Ujwal