Christopher Browne cbbrowne
Mon Nov 6 08:53:27 PST 2006
Szabolcs BALLA <szballa at confinsystems.com> writes:
> Hi,
>
> I stared to play with Slony-1.2 on Debian(3.1) system.
> I have a questions about this:
> 1. I see on my db server all the time this query:  FETCH 100 from LOG;
> what does it mean? Why it is doing this?

Normal.  This is the query pulling records to be applied to a
subscriber.

> 2. If I stop the slon on the master (slave is running) and I started
> couple of hour later (many insert and update later) It seems to me does
> not want to sync.
> Maybe I missed to configure something. Could anyone send me a debian
> based config file to check how it sholuld look like?

Hmm.

The standard question: look to the logs, particularly on the
subscriber.  What do you see there?

There is a whole section in the docs now as to what the various log
messages mean.
-- 
let name="cbbrowne" and tld="ca.afilias.info" in String.concat "@" [name;tld];;
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)



More information about the Slony1-general mailing list