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
e-
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 could simplify it by only having :
02
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 script
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 intended
to
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
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 modify the
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 someone share his script, or can I find it on the CVS (please
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 someone
es 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, 16 Dec 1999, Nicolas Huillard wrot
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
: '[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, 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
make a tar.gz
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't want
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]
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 his
15 matches
Mail list logo