In response to "Al Rosenthal" <arosenthal at AtlantaHand.com>:

> I have thought about firewalls and timeouts.  I just have two machines, 
> sitting next to each other connected by a switch.  One has Vista, the other 
> XP.  I tried running the slon engines on either one.  I also tried changing 
> all of the IP settings available.  I also tried adding a linux machine and 
> running the slon process on that machine.  In every case, the machine that 
> is the slave failed after about 12 - 15 GB with a error 10055 (not enough 
> buffer space or enough tcp buffers).

Perhaps try bumping up slon's log level and try to correlate what it's doing
when the problem occurs.

> Also, the database I am trying to 
> replicate is very simple.  One table, no indexes.  Even the table is simple. 
> On serial column as primary key, the other is bytea data.

Note that Slony can not replicate bytea fields.

> Any suggestions?

Don't top-post?

> >> What I still can not do is replicate a 22 GB database.  My initial
> >> trials all failed after about 12 to 15 GB with an error 10055 in
> >> the logs.  According to windows knowlegebase, this is because of a
> >> lack of TCP buffers.  I followed microsoft's advice and edited the
> >> registry and changed such things as the MaxUserPort and
> >> TCPTimedWaitDelay and TcpNumConnections to their maximums.
> 
> >I wonder if you're timing out.  What I know about Windows any more is
> >very close to zero, but my suspicion is that you might be building an
> >index or something that is taking a long time.  You will have issued
> >a command, and then you wait for it to complete.  If the time to
> >complete is longer than the time your settings are willing to wait,
> >then you can get in trouble.  (This could also be due to an
> >intermediate firewall deciding that your session is "idle".) 
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
> 
> 
> 
> 
> 
> 


-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran at collaborativefusion.com
Phone: 412-422-3463x4023

****************************************************************
IMPORTANT: This message contains confidential information and is
intended only for the individual named. If the reader of this
message is not an intended recipient (or the individual
responsible for the delivery of this message to an intended
recipient), please be advised that any re-use, dissemination,
distribution or copying of this message is prohibited. Please
notify the sender immediately by e-mail if you have received
this e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The
sender therefore does not accept liability for any errors or
omissions in the contents of this message, which arise as a
result of e-mail transmission.
****************************************************************