Re: 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
---------------------------------------------------------------