> Hi all,
>
> I'm new to Slony-I, and want to understand more about how the basic
> functionality works.
> Hopefully someone can help me on this:
> If I just installed basic Slony-I without any Failover or HA components,
> Master running on serverA and Slave running on serverB.
> What happens to the slave database if the network falls between serverA
> and
> serverB for a short period and resumes back later (eg, 1-2 minutes),
> and someone had been updated the master database for that period? Will the
> slave database sync the changes after the network resumed?

Generally, yes.

A problem can then come up...

It is possible that databases may be unaware that the connections have
been chopped out from between slons and databases.

We have hit this, on occasion, normally when a WAN connection has gone bad.

When this happens, there are <IDLE> or <IDLE> in transaction connections
left around; they'll prevent new slon connections from starting up until
either:
 a) You kill off the connections, or
 b) TCP/IP timeouts take place, which tends to take a couple hours.