On Thu, 16 Dec 1999, Nicolas Huillard wrote:
> Thanks for this very simple and beautiful line !
> You could simplify it by only having :
> 02 0 * * * echo "vacuum verbose;" | psql faq
>
> Frankly, I'd prefer a script that automatically adapt to any added
> database in the whole system : as an administrator, I don't want to edit
> my/postgres crontab each time a new DB is added to Postgres...
Debian GNU/Linux system distrubuted with excelent script of this sort -
it asks Postgres, get a list of DBs and vacuum them all in a loop.
Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
************