VACCUM VERBOSE ANALYZE - Mailing list pgsql-novice

From Cédric BUSCHINI
Subject VACCUM VERBOSE ANALYZE
Date
Msg-id 4469C0AD.60802@carax.com
Whole thread Raw
Responses Re: VACCUM VERBOSE ANALYZE
List 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@DBsrv] # psql -c'VACUUM VERBOSE analyze' > /home/log_vaccum
--------------
the same command in a script without the '> /home/log_vaccum'
[USER@DBsrv] # vaccum.sh > /home/log_vaccum
--------------
[USER@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

pgsql-novice by date:

Previous
From: Verena Ruff
Date:
Subject: tools analyzing EXPLAIN
Next
From: Tom Lane
Date:
Subject: Re: VACCUM VERBOSE ANALYZE