Yes, the write access is fine. I think I have a problem with syntax. I don't know if there is a command switch on psql to redirect standard output to a logfile. THere is one for any query results, but that does not happen to contain the output of vacuum.
On 12/4/07, Martin Gainty <mgainty@hotmail.com> wrote:does psql have write access to the folder?
M-
----- Original Message -----
Sent: Tuesday, December 04, 2007 10:27 AM
Subject: [GENERAL] Vacuum output redirect
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.
--
Do you want to make a difference? Issue a microloan at
www.kiva.org.