I'm no expert but have you tried vacuuming the master and slave databases?

John Sidney-Woollett

Michel.Diotte at hydro.com wrote:
> 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_
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> 
> 
> ***********************************************************************
> 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.
> ***********************************************************************
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general