From:
Peter Eisentraut <peter_e(at)gmx(dot)net>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>,PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: [COMMITTERS] pgsql-server/ oc/src/sgml/manage-ag.sgml oc/sr ...
Date:
2003-03-21 17:05:36
Message-ID:
Pine.LNX.4.44.0303211443380.2387-100000@peter.localdomain (view raw or flat )
Thread:
2003-03-18 22:19:47 from petere(at)postgresql(dot)org (Peter Eisentraut - PostgreSQL)
2003-03-19 01:33:22 from "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
2003-03-19 01:34:15 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-03-20 16:19:00 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2003-03-20 16:22:01 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-03-20 16:55:09 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2003-03-20 16:58:25 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-03-20 17:22:28 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2003-03-20 17:25:03 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-03-20 17:31:29 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2003-03-20 17:33:18 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2003-03-20 17:39:12 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2003-03-21 17:05:36 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2003-03-21 17:15:19 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Lists:
pgsql-committers 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(at)gmx(dot)net
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2003-03-21 17:12:22Subject : Re: cursors: SCROLL default, error messages Previous :From : Peter EisentrautDate : 2003-03-21 17:03:27Subject : Re: [INTERFACES] Roadmap for FE/BE protocol redesign
pgsql-committers by date
Next :From: Bruce Momjian - CVSDate: 2003-03-21 17:11:46Subject : pgsql-server/doc/src/sgml/ref declare.sgmlPrevious :From : Bruce Momjian - CVSDate : 2003-03-21 15:43:02Subject : pgsql-server/src/backend/commands tablecmds.c
