Re: Running vacuum on cron

Hello Pedro,

Two solutions
1) Give access to PostgreSQL from root user and run commands from 
/etc/crontab. Not secure.
2) su postgres and use the crontab command as explained in 
http://www.lysator.liu.se/~forsberg/linux/cron.html

Best regards,
Jean-Michel POURE


Hi. Is there any way to put a vacuum and a vacuum analyze (the
>second does everything the first does? Or do I need to use both?) in a cron
>so that it is executed nightly?
>
>         Thanks
>
>--
>Pedro Miguel G. Alves
>
>THINK - Tecnologias de Informação
>Av. Defensores de Chaves nº 15 4ºD, 1000-109 Lisboa Portugal
>Tel: +351 21 3590285   Fax: +351 21 3582729
>HomePage: www.think.co.pt
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org