Postgres Pro
Downloads
Home   >   mailing lists

Thread: capture vacuumdb verbose output

capture vacuumdb verbose output

From
Shankar K
Date:
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

Re: capture vacuumdb verbose output

From
Tom Lane
Date:
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

Re: capture vacuumdb verbose output

From
Jonathan Gardner
Date:
-----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-----

Re: capture vacuumdb verbose output

From
Shankar K
Date:
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