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