Re: Vacuum output redirect

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: 'PostgreSQL' <pgsql-general(at)postgresql(dot)org>
Subject: Re: Vacuum output redirect
Date: 2007-12-04 23:35:57
Message-ID: 4755E45D.7020504@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)iol(dot)ie
---------------------------------------------------------------

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-12-04 23:46:18 Re: [GENERAL] PostgreSQL Beta4 released
Previous Message Peck, Brian 2007-12-04 23:04:41 Create function errors