Re: pgsql-server/ oc/src/sgml/manage-ag.sgml oc/sr ...

On Thu, Mar 20, 2003 at 11:58:25AM -0500, Bruce Momjian wrote:
> Tom Lane wrote:
> > Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> > > Christopher Kings-Lynne writes:
> > >> Do you think we should replace them all with a utility called pg_maintain
> > >> that can do all of them?
> >
> > > If you ask me, we could get rid of them completely because
> > > for d in $(psql -l --somthing); do vacuum $d; done
> > > seems perfectly fine.
> >
> > 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 think an acceptable solution to Windows users is some kind of
"service" that can run whatever is needed, whenever is needed. Those
poor Windows users don't have cron, remember. IMHO this kind of tool is
part of the Windows administration package and probably doesn't belong
in the main distribution.

> That's why I am thinking of some wrapper that will loop through the
> databases and run psql commands.

Written on what language?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Limitate a mirar... y algun dia veras"