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