Hi ,
I have used slony1-1.0.1 for several months. I have only one slave (on the
same LAN )
Slony was running good , the slave following the master with a lag of 10
seconds.
The replication stopped 3 times in seven months due to time out, and i had
to restart the slon process on each machine to bring back the replication.
Yesterday,  i upgraded from 1.0.1 to 1.0.5 , run the folowing script to
update the functions, and started the slon process.
Since then, the slave is updated several minutes after a modification has
been done on the master.
Did i missed something in the upgrade process ?

This is the updateFunction script:

#!/bin/sh

CLUSTER=replication
DBNAME1=lims
DBNAME2=lims
HOST1=webapp
HOST2=webapp-2
SLONY_USER=slony
PASS_SLONY= ******


/usr/local/slony/src/slonik/slonik <<_EOF_

    cluster name = $CLUSTER;

    node 1 admin conninfo = 'dbname=$DBNAME1 host=$HOST1 user=$SLONY_USER
password=$PASS_SLONY';
    node 2 admin conninfo = 'dbname=$DBNAME2 host=$HOST2 user=$SLONY_USER
password=$PASS_SLONY';

    # ----
    # update Node 1
    # ----
    update functions (id = 1);

    # ----
    # update Node 2
    # ----
    update functions (id = 2);

_EOF_


-------------- next part --------------


***********************************************************************
NOTICE: This e-mail transmission, and any documents, files or previous
e-mail messages attached to it, may contain confidential or privileged
information. If you are not the intended recipient, or a person
responsible for delivering it to the intended recipient, you are
hereby notified that any disclosure, copying, distribution or use of
any of the information contained in or attached to this message is
STRICTLY PROHIBITED. If you have received this transmission in error,
please immediately notify the sender and delete the e-mail and attached
documents. Thank you.
***********************************************************************