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.