Postgres Pro
Downloads
Home   >   mailing lists

Re: VACCUM VERBOSE ANALYZE - Mailing list pgsql-novice

From Tom Lane
Subject Re: VACCUM VERBOSE ANALYZE
Date
Msg-id 11803.1147787803@sss.pgh.pa.us
Whole thread Raw
In response to VACCUM VERBOSE ANALYZE  (Cédric BUSCHINI <cbuschini@carax.com>)
Responses Re: VACCUM VERBOSE ANALYZE
List pgsql-novice
Tree view 
=?ISO-8859-1?Q?C=E9dric_BUSCHINI?= <cbuschini@carax.com> writes:
> 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
> --------------

I think that output goes to stderr not stdout.  Try

psql -c'VACUUM VERBOSE analyze' 2> /home/log_vaccum

            regards, tom lane

pgsql-novice by date:

Previous
From: Cédric BUSCHINI
Date:
Subject: VACCUM VERBOSE ANALYZE
Next
From: Cédric BUSCHINI
Date:
Subject: Re: VACCUM VERBOSE ANALYZE