On 1999-12-16, [EMAIL PROTECTED] mentioned:
> On Thu, 16 Dec 1999, Peter Eisentraut wrote:
> > Actually such a script, called vacuumdb, with exactly those options is
> > included in the distribution and should be installed in your bin dir right
> > next to psql.
>
> Unfortunately, the vacuumdb script does not run through
> *all* your databases, only one that you specify. The other
> scripts that have been posted will vacuum all databases in
> a host installation.
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.
Perhaps this sort of option should be included in the script though, as it
is clearly needed by a lot of people. Will ponder.
--
Peter Eisentraut Sernanders väg 10:115
[EMAIL PROTECTED] 75262 Uppsala
http://yi.org/peter-e/ Sweden
************
