| From: | "Wim Chalmet" <wim(dot)chalmet(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Vacuum output redirect |
| Date: | 2007-12-04 15:27:44 |
| Message-ID: | b29c4c2a0712040727j669fb825oae053ef598f04690@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pau Marc Munoz Torres | 2007-12-04 15:41:18 | Can i Force to postgrsql to use a certain index? |
| Previous Message | Glen W. Mabey | 2007-12-04 15:26:46 | Re: difficulty extracting variable-sized field on triggered row |