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