Thread: Logging improvements and rehashing
Hello It would be very nice to create a way to log only bad queries, which's resulted in an error. This way a higher loglevel wouldn't be necessary. one other thing, by sending a SIGHUP to the postmaster it reinits it's config files. Now i've made some store functions in C, and it would be very nice, if postgres had re-opened these modules somehow. after overwriting the module with the fresh-compiled version, the first query always crashed the backend. Bye, Gergely Czuczy mailto: phoemix@harmless.hu PGP: http://phoemix.harmless.hu/phoemix.pgp The point is, that geeks are not necessarily the outcasts society often believes they are. The fact is that society isn't cool enough to be included in our activities.
Czuczy Gergely <phoemix@harmless.hu> writes:
> It would be very nice to create a way to log only bad queries, which's
> resulted in an error. This way a higher loglevel wouldn't be necessary.
We have that (might be new for 7.4, I forget).
> i've made some store functions in C, and it would be very nice, if
> postgres had re-opened these modules somehow.
See LOAD.
regards, tom lane
Tom Lane wrote: > Czuczy Gergely <phoemix@harmless.hu> writes: > > It would be very nice to create a way to log only bad queries, which's > > resulted in an error. This way a higher loglevel wouldn't be necessary. > > We have that (might be new for 7.4, I forget). Yes, new for 7.4: log_min_error_statement. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073
On Fri, 2003-09-05 at 16:41, Bruce Momjian wrote:
> Tom Lane wrote:
> > Czuczy Gergely <phoemix@harmless.hu> writes:
> > > It would be very nice to create a way to log only bad queries, which's
> > > resulted in an error. This way a higher loglevel wouldn't be necessary.
> >
> > We have that (might be new for 7.4, I forget).
>
> Yes, new for 7.4: log_min_error_statement.
>
Actually it is in 7.3 as well
7.4 does have some new options though, including log_min_messages (or is
that the same as server_min_messages in 7.3?), log_error_verbosity, and
log_min_duration_statement.
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Robert Treat wrote: > On Fri, 2003-09-05 at 16:41, Bruce Momjian wrote: > > Tom Lane wrote: > > > Czuczy Gergely <phoemix@harmless.hu> writes: > > > > It would be very nice to create a way to log only bad queries, which's > > > > resulted in an error. This way a higher loglevel wouldn't be necessary. > > > > > > We have that (might be new for 7.4, I forget). > > > > Yes, new for 7.4: log_min_error_statement. > > > > Actually it is in 7.3 as well > > 7.4 does have some new options though, including log_min_messages (or is > that the same as server_min_messages in 7.3?), log_error_verbosity, and > log_min_duration_statement. Oh, yes, good catch. Thanks. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073