Tom Lane wrote:
Ron St-Pierre <[EMAIL PROTECTED]> writes:Oops, I'm running bash. I just redirected stderr to the file
One question about redirecting VACUUMs output to file though. When I run:
psql -d imperial -c "vacuum full verbose analyze;" > vac.info
vac.info contains only the following line:
VACUUM
I've been unable to capture the VERBOSE output to file. Any suggestions?
You need to catch stderr not only stdout.
(I'd be less vague if I knew which shell you were running, but sh- and csh-derived shells do it differently.)
psql -d imperial -c "vacuum full verbose analyze;" 2> /usr/local/pgsql/vac.info
which gives me exactly what I want.
Thanks again Tom
Ron
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
