Thread: Vacuum output redirect

On 04/12/2007 15:27, Wim Chalmet wrote:

> 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?

You could use the standalone program vacuumdb and redirect its output, thus:

   vacuumdb -U postgres your_database >out.txt 2>&1

HTH

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

----- 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.

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.




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