On 8 Jul, Lamar Owen wrote:
> Try the following one-liner (yes, one liner. e-mail will break it up,
> and the syntax is kindof picky -- xargs is a great tool, even if it is a
> little farkled):
>
> psql -t -c "select datname from pg_database" template1|xargs -n 1 psql
> -q -c "vacuum analyze
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
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 intende
