Vacuum output redirect - Mailing list pgsql-general

From Wim Chalmet
Subject Vacuum output redirect
Date
Msg-id b29c4c2a0712040727j669fb825oae053ef598f04690@mail.gmail.com
Whole thread Raw
List pgsql-general
Hi,
 
Sorry for my basic question here, but I can't figure things out. I am running postgres in a windows environment. I would like to redirect the output from a "vacuum full analyze verbose;" to a text file. How do I do this?
 
I have tried this (the file "run_vacuum.sql" just contains this one line - without quotes of course: "vacuum full analyze verbose;" )
psql -d sirius_lm -U postgres -f run_vacuum.sql -o vacuum.log
 
And also this:
psql -d sirius_lm -U postgres -f run_vacuum.sql >vacuum.log
 
But none of that works. Can anybody help a beginner out? Thanks!

--
Do you want to make a difference? Issue a microloan at www.kiva.org.

pgsql-general by date:

Previous
From: cliff@krumvieda.com
Date:
Subject: Transaction isolation and constraints
Next
From: "Pau Marc Munoz Torres"
Date:
Subject: Can i Force to postgrsql to use a certain index?