Re: Overwhelming DEBUG messages - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Overwhelming DEBUG messages
Date
Msg-id 200305081906.40734.dev@archonet.com
Whole thread Raw
In response to Overwhelming DEBUG messages  ("SZŰCS Gábor" <surrano@mailbox.hu>)
Responses Re: Overwhelming DEBUG messages  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: "SZŰCS Gábor"
Date:
Subject: Overwhelming DEBUG messages
Next
From: Tom Lane
Date:
Subject: Re: Overwhelming DEBUG messages