Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

> On Sun, 26 Jul 1998, Herouth Maoz wrote:
>
> > At 23:36 +0300 on 24/7/98, Richard Lynch wrote:
> >
> >
> > > Well, let's try crontab -e and mess around to find out the answers to these
> > > questions.  Or at least to see if I can just ignore this whole MAILTO thing
> > > for now.  I can always do crontab -r and blow it away.
> >
> > I nearly fell off my chair laughing... You know, on my personal TODO list
> > there's a little item "Write crons for VACUUM", which has been there for
> > months, and I keep postponing it.
>
> I'm another one of those people... so I wrote a quick & dirty c program to
> vacuum ALL my databases.  I just mailed it to Marc Fournier
> (scrappy@hub.org) because I didn't know what to do with it, but if anyone
> else wants it just drop me a line directly.
>

Here is a little shell script to do it.


--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)
psql -l -A -q -t|cut -d"|" -f1 | while read DATABASE
    do
        psql -q -c vacuum $DATABASE
    done