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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
