Re: [COMMITTERS] pgsql-server/ oc/src/sgml/manage-ag.sgml oc/sr ... - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [COMMITTERS] pgsql-server/ oc/src/sgml/manage-ag.sgml oc/sr ...
Date
Msg-id Pine.LNX.4.44.0303211443380.2387-100000@peter.localdomain
Whole thread Raw
Responses Re: [COMMITTERS] pgsql-server/ oc/src/sgml/manage-ag.sgml
List pgsql-hackers
Tom Lane writes:

> > for d in $(psql -l --somthing); do vacuum $d; done
> If you have a real shell (and know how to use it), sure.  Is such a
> solution acceptable to all those Windows users we're hoping to attract?

I don't know how Windows users typically manage their systems, but if they
use batch files they can also write a similar loop with the native shell.
(I just tried it.)

My problem with a program that runs a command for all databases is that it
is too rigid:  What if you want to run maintenance only on some databases
(owned by you, big/small, even/odd, starting with 'x')?  --- Cannot use
it, back to the manual approach.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [INTERFACES] Roadmap for FE/BE protocol redesign
Next
From: Tom Lane
Date:
Subject: Re: cursors: SCROLL default, error messages