On Thu, 16 Dec 1999, Nicolas Huillard wrote:
> Hello,
>
> Does anybody already wrote a cron script that periodically (with cron) vacuum all
>(or part of all) database on a single server ?
> I'm sure everyone has this kind of stuff :
> $ pg_vacuum [-h hostname] [-u] [options] [dbname]
>
> Can someone share his script, or can I find it on the CVS (please tell me where,
>because I've never used that)
Hi, I have this line in my crontab:
02 0 * * * /usr/bin/psql faq < /home/michel/bin/vacuum
and /home/michel/bin/vacuum is:
vacuum verbose;
Ok, this is not the best, but it works,
Errare è umano, ma per fare veramente casino ci vuole la password di root.
--
Michel <ZioBudda> Morelli [EMAIL PROTECTED]
http://ziobudda.enter.it
Italian Linux FAQ http://ziobudda.enter.it/FAQ/
Italian Linux Press http://ziobudda.enter.it/ILP/
************