> On Fri, 17 Dec 1999, Bruce Momjian wrote:
>
> > > It would be nice for new users; I think it would make it easier
> > > for them to actually set out and do it. Many new users are
> > > of the not-so-knowledgable variety, and shell scripting isn't
> > > something they want to undertake.
> >
>
On Fri, 17 Dec 1999, Bruce Momjian wrote:
> > It would be nice for new users; I think it would make it easier
> > for them to actually set out and do it. Many new users are
> > of the not-so-knowledgable variety, and shell scripting isn't
> > something they want to undertake.
>
> Can someone mo
> 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
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
On 1999-12-16, [EMAIL PROTECTED] mentioned:
> 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 s
essage d'origine-
De: Lamar Owen [SMTP:[EMAIL PROTECTED]]
Date: jeudi 16 décembre 1999 17:44
À: Nicolas Huillard
Cc: '[EMAIL PROTECTED]'
Objet: Re: [ADMIN] Vacuum script
Nicolas Huillard wrote:
>
> Thanks for this very simple and beautiful line !
> You c
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 Thu, 16 Dec 1999, Peter Eisentraut wrote:
> On 1999-12-16, Nicolas Huillard mentioned:
> 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.
>
> I think it's not in the RPMs though.
On 1999-12-16, Nicolas Huillard mentioned:
> Does anybody already wrote a cron script that periodically (with cron)
> vacuum all (or part of all) database on a single server ? I'm sure
> everyone has this kind of stuff :
> $ pg_vacuum [-h hostname] [-u] [options] [dbname]
>
> Can someone share h
Here is a perl script I use for vacuuming. It's
in my postgres crontab, so that it runs with the
proper environment variables. There's probably
a more elegant solution, but this works okay for
me.
--Keith
[EMAIL PROTECTED]
#!/usr/bin/p
jeudi 16 décembre 1999 15:45
>À: Nicolas Huillard
>Cc: '[EMAIL PROTECTED]'
>Objet: RE: [ADMIN] Vacuum script
>
> Debian GNU/Linux system distrubuted with excelent script of this sort -
>it asks Postgres, get a list of DBs and vacuum them all in
Nicolas Huillard wrote:
>
> Thanks for this very simple and beautiful line !
> You could simplify it by only having :
> 02 0 * * * echo "vacuum verbose;" | psql faq
>
> Frankly, I'd prefer a script that automatically adapt to any added database in the
>whole system : as an administrator, I don'
On Thu, 16 Dec 1999, Mark Jewiss wrote:
> Hello,
>
> On Thu, 16 Dec 1999, ZioBudda wrote:
>
> > > Can someone share his script, or can I find it on the CVS (please
> > tell me where, because I've never used that)
>
> I've got a perl script which will look through what db's you have, then
> mak
rd
Cc: '[EMAIL PROTECTED]'
Objet: RE: [ADMIN] Vacuum script
Debian GNU/Linux system distrubuted with excelent script of this sort -
it asks Postgres, get a list of DBs and vacuum them all in a loop.
Oleg.
On Thu, 16 Dec 1999, Nicolas Huillard wrote:
> Thanks for this very simple and beautiful line !
> You could simplify it by only having :
> 02 0 * * * echo "vacuum verbose;" | psql faq
>
> Frankly, I'd prefer a script that automatically adapt to any added
> database in the whole system : as an ad
my/postgres crontab each time
a new DB is added to Postgres...
Nicolas
-Message d'origine-
De: ZioBudda [SMTP:[EMAIL PROTECTED]]
Date: jeudi 16 décembre 1999 15:09
À: Nicolas Huillard
Cc: '[EMAIL PROTECTED]'
Objet: Re: [ADMIN] Vacuum script
On Thu,
On Thu, 16 Dec 1999, Nicolas Huillard wrote:
> Hello,
>
> Does anybody already wrote a cron script that periodically (with cron) vacuum all
>(or part of all) database on a single server ?
> I'm sure everyone has this kind of stuff :
> $ pg_vacuum [-h hostname] [-u] [options] [dbname]
>
> Can s
17 matches
Mail list logo
