| From: | Cédric BUSCHINI <cbuschini(at)carax(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | VACCUM VERBOSE ANALYZE |
| Date: | 2006-05-16 12:08:13 |
| Message-ID: | 4469C0AD.60802@carax.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hello,
I would like to save in a file log from a "VACUUM VERBOSE analyze"
perform from psql.
I ve tried different ways :
--------------
[USER(at)DBsrv] # psql -c'VACUUM VERBOSE analyze' > /home/log_vaccum
--------------
the same command in a script without the '> /home/log_vaccum'
[USER(at)DBsrv] # vaccum.sh > /home/log_vaccum
--------------
[USER(at)DBsrv]# psql
Welcome to psql 8.0.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
DBsrv=# VACUUM VERBOSE analyze; \o /home/log_vaccum
--------------
..... but no one worked :(
The log file is created but empty.
Does any one got an idea ?
Cheers
Cedric
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-05-16 13:56:43 | Re: VACCUM VERBOSE ANALYZE |
| Previous Message | Dušan PEŠL | 2006-05-16 11:34:33 | selecting un-ordered rows |