Skip site navigation (1) Skip section navigation (2)

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

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter_e(at)gmx(dot)net>,Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>,pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql-server/ oc/src/sgml/manage-ag.sgml oc/sr ...
Date: 2003-03-20 17:22:28
Message-ID: 20030320172227.GB3257@dcc.uchile.cl (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-hackers
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"

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2003-03-20 17:25:03
Subject: Re: pgsql-server/ oc/src/sgml/manage-ag.sgml oc/sr ...
Previous:From: Bruce MomjianDate: 2003-03-20 16:58:25
Subject: Re: pgsql-server/ oc/src/sgml/manage-ag.sgml oc/sr ...

pgsql-committers by date

Next:From: Bruce MomjianDate: 2003-03-20 17:25:03
Subject: Re: pgsql-server/ oc/src/sgml/manage-ag.sgml oc/sr ...
Previous:From: Bruce MomjianDate: 2003-03-20 16:58:25
Subject: Re: pgsql-server/ oc/src/sgml/manage-ag.sgml oc/sr ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group