does psql have write access to the folder? M- ----- Original Message ----- From: Wim Chalmet To: pgsql-general@postgresql.org 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.
