> On 18 Dec, Peter Eisentraut wrote:
> > Point granted, but you could use something like this
> >
> > for db in `psql -t -A -d template1 -c "select datname from\
> > pg_database"`; do vacuum $db ; done
> >
> > rather than re-inventing the wheel.
>
> Certainly. I wrote my perl script because I originally intended
> to do other database-maintenance with it as well. Of course,
> that hasn't happened yet.... :-)
>
> > Perhaps this sort of option should be included in the script though, as it
> > is clearly needed by a lot of people. Will ponder.
>
> It would be nice for new users; I think it would make it easier
> for them to actually set out and do it. Many new users are
> of the not-so-knowledgable variety, and shell scripting isn't
> something they want to undertake.
Can someone modify the vacuumdb shell script to do that?
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
************
