
> New LOG level the prints to server log by default

> Cause VACUUM information to print only to the client in verbose mode
> VACUUM doesn't output to server logs

Why that ? For me vacuum was one of the more useful messages in the log.
Or have you added a separate elog(LOG,... ?
It told me whether the interval between vacuums was good or not. 

Andreas

Fri, 1 Mar 2002 12:38:31 +0100
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>
Re: elog() patch
Zeugswetter Andreas SB SD wrote:
> 
> > New LOG level the prints to server log by default
> 
> > Cause VACUUM information to print only to the client in verbose mode
> > VACUUM doesn't output to server logs
> 
> Why that ? For me vacuum was one of the more useful messages in the log.
> Or have you added a separate elog(LOG,... ?
> It told me whether the interval between vacuums was good or not. 

If you set server_min_messages to DEBUG1, you will get those in the log.
Vacuum was unusual because it was doing DEBUG to the log and not to the
user.  I can change this so it does LOG to the log all the time.  I
changed it to DEBUG1 because I was not sure every VACUUM show be spewing
to the log file.  It didn't see like a standard log message.

Another option is to set server_min_messages to INFO and do a VACUUM
VERBOSE.  That will force those to the log without other DEBUG1
messages.  As you can see, this is going to allow more control over
sending information to different places.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 1 Mar 2002 10:07:31 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: elog() patch
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Vacuum was unusual because it was doing DEBUG to the log and not to the
> user.  I can change this so it does LOG to the log all the time.

I think that VACUUM's messages should not appear at the default logging
level (which is going to be LOG, no?).  DEBUG1 seems a reasonable level
for VACUUM.

What exactly will VACUUM VERBOSE do?

			regards, tom lane

Fri, 01 Mar 2002 12:34:34 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: elog() patch 
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Vacuum was unusual because it was doing DEBUG to the log and not to the
> > user.  I can change this so it does LOG to the log all the time.
> 
> I think that VACUUM's messages should not appear at the default logging
> level (which is going to be LOG, no?).  DEBUG1 seems a reasonable level
> for VACUUM.

Right.

> What exactly will VACUUM VERBOSE do?

VACUUM VERBOSE will send INFO vacuum stats to client, and if you set
server_min_messages to INFO, you will get them in the logs too.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 1 Mar 2002 13:07:59 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: elog() patch
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> What exactly will VACUUM VERBOSE do?

> VACUUM VERBOSE will send INFO vacuum stats to client, and if you set
> server_min_messages to INFO, you will get them in the logs too.

So VACUUM will use either INFO or DEBUG1 level depending on VERBOSE,
and from there it works as usual.  Seems okay.

			regards, tom lane

Fri, 01 Mar 2002 14:06:35 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: elog() patch 
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> >> What exactly will VACUUM VERBOSE do?
> 
> > VACUUM VERBOSE will send INFO vacuum stats to client, and if you set
> > server_min_messages to INFO, you will get them in the logs too.
> 
> So VACUUM will use either INFO or DEBUG1 level depending on VERBOSE,
> and from there it works as usual.  Seems okay.

Yep.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 1 Mar 2002 14:11:40 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: elog() patch