Skip site navigation (1) Skip section navigation (2)

VACCUM VERBOSE ANALYZE

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 (view raw or flat)
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

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2006-05-16 13:56:43
Subject: Re: VACCUM VERBOSE ANALYZE
Previous:From: Dušan PEŠLDate: 2006-05-16 11:34:33
Subject: selecting un-ordered rows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group