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: | Raw Message | Whole Thread | 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 |