| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | " SZŰCS =?iso-8859-2?q?=20G=E1bor?=" <surrano(at)mailbox(dot)hu>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Overwhelming DEBUG messages |
| Date: | 2003-05-08 18:06:40 |
| Message-ID: | 200305081906.40734.dev@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-05-08 18:38:29 | Re: Overwhelming DEBUG messages |
| Previous Message | SZŰCS Gábor | 2003-05-08 16:51:35 | Overwhelming DEBUG messages |