[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]
From:       Bruce Momjian <maillist () candle ! pha ! pa ! us>
Date:       1998-07-28 7:13:24
[Download RAW message or body]

> 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)

["/tmp/pg_vacuum" (text/plain)]

psql -l -A -q -t|cut -d"|" -f1 | while read DATABASE
	do
		psql -q -c vacuum $DATABASE
	done



[prev in list] [next in list] [prev in thread] [next in thread]