Re: Lots of junk on my console

On Thu, 29 Mar 2007, Joseph S wrote:

> Joseph S wrote:
>> I append ?loglevel=1 to the db connection urls I use for running VACUUM
>> commands.  Would that set the logwriter?
>>
> Actually I see that it does.  The comment in AbstractJdbc2Connection reads:
>
>        // Read loglevel arg and set the loglevel based on this value;
>        // In addition to setting the log level, enable output to
>        // standard out if no other printwriter is set
>
> So I guess I have to set it back to null each time I create a db connection.
>

Perhaps you should avoid using loglevel=1 if you don't want any logging
output.  If you want to get VACUUM details that should be available in a
SQLWarning attached to the statement and should be easier to put where you
want than something that is dumped to stdout.

Kris Jurka