Обсуждение: capture vacuumdb verbose output
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
Shankar K <shan0075@yahoo.com> writes:
> 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
I think that output will go to stderr.
regards, tom lane
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Monday 02 June 2003 12:25, Tom Lane wrote: > Shankar K <shan0075@yahoo.com> writes: > > 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 > > I think that output will go to stderr. > - From Bash, you can use the common idiom "2>&1". # the_command 2>&1 >> the_logfile This will capture stderr as well as stdout. - -- Jonathan Gardner <jgardner@jonathangardner.net> (was jgardn@alumni.washington.edu) Live Free, Use Linux! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQE+3g8qWgwF3QvpWNwRAp7oAKCvmS6Li6NoZeWqcutMRvwaNQ3VFgCgqP86 Og8aNP/SkGXO44B7DjYvvzU= =Ixax -----END PGP SIGNATURE-----
Thanks Jonathan, tom... --- Jonathan Gardner <jgardner@jonathangardner.net> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On Monday 02 June 2003 12:25, Tom Lane wrote: > > Shankar K <shan0075@yahoo.com> writes: > > > 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 > > > > I think that output will go to stderr. > > > > - From Bash, you can use the common idiom "2>&1". > > # the_command 2>&1 >> the_logfile > > This will capture stderr as well as stdout. > > - -- > Jonathan Gardner <jgardner@jonathangardner.net> > (was jgardn@alumni.washington.edu) > Live Free, Use Linux! > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.1 (GNU/Linux) > > iD8DBQE+3g8qWgwF3QvpWNwRAp7oAKCvmS6Li6NoZeWqcutMRvwaNQ3VFgCgqP86 > Og8aNP/SkGXO44B7DjYvvzU= > =Ixax > -----END PGP SIGNATURE----- > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster __________________________________ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com