[Mapbender-dev] Telascience autoupdate disabled

[Seven of Nine (aka Arnulf)]

On Sat, 2010-04-10 at 18:11 +0200, Karim Malhas wrote:
> Dear all,
> 
> > I disabled the automatic updates at mapbender.telascience.org
> > Loading the updatesqls takes nearly 1.5h for some reason.
> > Up until now, an update was started every 10 minutes, resulting in a very
> > broken system.
> 
> So today I investigated and found out that updating every 10 minutes is
> too much if postgres is not autovacuumed.
> 
> Does anyone know why there are two postgres installations (8.0.8 and
> 8.1.5) are on that system. (The currently active version is 8.0.8)
> 
> 
> And a note:
> 
> The cronjob contained these lines:
> 
> */10 * * * * svnupdate
> */11 * * * * dbupdate
> 
> That runs svnupdate every 10 minutes and dbupdate every 11 minutes

Hehe. No wonder that the machine choked on that. 

Thanks for fixing. 

> I don't think thats what is intended, which would rather be: "run dbupdate one minute
> after svnupdate" 
> To accomplish this I suggest we make a single script that runs 
> svnupdate waits for it to finish, and then runs dbupdate
> 
> 
> In fact I have taken the liberty of doing exactly that. 
> The script can be found at /usr/local/bin/mapbender_update
> 
> 
> Regards,
> Karim
> _______________________________________________
> Mapbender_dev mailing list
> Mapbender_dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapbender_dev