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.
-- Keith
[EMAIL PROTECTED]
maintainer of alt.os.linux.slackware FAQ
************
