Geoffrey wrote:
> Noticed yesterday that the same two tables on all our databases (12) 
> are out of sync.  I've just noticed today that the date on the slave 
> is 1 hour behind the master.  Is it possible that this time difference 
> could cause any problems with slony replication?
>
In what sense are they "out of sync"?

Slony-I doesn't use timestamps to control its behaviour; it uses 
internal transaction IDs, so this seems rather surprising.

I'd appreciate it a lot if you could do some poking at it to see if you 
could determine where specifically the problem arose, as  it would be a 
LOT better to be able to give specific diagnosis of "make sure X doesn't 
happen to your system!" rather than merely saying "oh, you shouldn't let 
times get TOO out of sync otherwise there might be some problems..."

-- 
(format nil "~S@~S" "cbbrowne" "ca.afilias.info")
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)
"Bother,"  said Pooh,  "Eeyore, ready  two photon  torpedoes  and lock
phasers on the Heffalump, Piglet, meet me in transporter room three"