Re: Vacuum output redirect - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Vacuum output redirect
Date
Msg-id 4755E45D.7020504@iol.ie
Whole thread Raw
In response to Vacuum output redirect  ("Wim Chalmet" <wim.chalmet@gmail.com>)
List pgsql-general
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
---------------------------------------------------------------


pgsql-general by date:

Previous
From: "Peck, Brian"
Date:
Subject: Create function errors
Next
From: "Joshua D. Drake"
Date:
Subject: Re: PostgreSQL Beta4 released