Re: Overwhelming DEBUG messages

On Thursday 08 May 2003 5:51 pm, SZŰCS Gábor wrote:
> My problem is: I'd like to see DEBUG messages in the server log, but if I
> set SERVER_MIN_MESSAGES to debug (also tried debug1 and debug5), the log
> gets filled with these:
>
> 2003-05-08 18:39:57 [12788]  DEBUG:  StartTransactionCommand
> 2003-05-08 18:39:57 [12788]  DEBUG:  CommitTransactionCommand
>
> Is there a way to configure postgres (including compile-time) not to log
> such in the server log?

IANAD (I am not a developer) but you've probably got two options:

1. Go through the source and comment out "elog()" calls you don't want.
2. Write a short script to grep out the lines you don't want to see.

The second could be done with something along the lines of: grep -v -f file-with-patterns-in-it

--  Richard Huxton