capture vacuumdb verbose output

From: Shankar K <shan0075(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: capture vacuumdb verbose output
Date: 2003-06-02 18:29:59
Message-ID: 20030602182959.26575.qmail@web21103.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi there,

i'm trying to log the verbose output of vaccumdb to a
file along with other details, but i only end up with
logging this

-------------------------------------------------------------
Begin vacuum/analyze db at Mon Jun 2 10:37:29 PDT
2003
Vacuuming test
SET autocommit TO 'on';SET vacuum_mem to 51200;VACUUM
VERBOSE ANALYZE
VACUUM
Vacuuming template1
SET autocommit TO 'on';SET vacuum_mem to 51200;VACUUM
VERBOSE ANALYZE
VACUUM
Vacuum / Analyze db successful.
End vacuum/analyze db at Mon Jun 2 10:37:32 PDT 2003
-------------------------------------------------------------

<snip from script>

..
echo
"-------------------------------------------------------------"
> $LOGS_DIR/$log_filename
echo "Begin vacuum/analyze db at `date`" >>
$LOGS_DIR/$log_filename

$PGSQL_HOME/bin/vacuumdb -e -a -z -v >>
$LOGS_DIR/$log_filename
...

</end snip>

so how to log the verbose output to a file. i tried
2>logfile, but that didn't work the way i want it to.

any ideas is really appreciated.

Shankar

__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-06-02 19:25:05 Re: capture vacuumdb verbose output
Previous Message Bodanapu, Sravan 2003-06-02 14:23:58 Re: Error while loading external data into Postgres table