pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedOverwhelming DEBUG messages
4+ messages / 3 participants
[nested] [flat]
* Overwhelming DEBUG messages
@ 2003-05-08 16:51 SZŰCS Gábor <surrano@mailbox.hu>
2003-05-08 18:06 ` Re: Overwhelming DEBUG messages Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 4+ messages in thread
From: SZŰCS Gábor @ 2003-05-08 16:51 UTC (permalink / raw)
To: pgsql-sql
I know this should probably go to pgsql-general or more likely pgsql-novice,
but I'm not willing to subscribe either (tee-hee). Also, I have searched the
archives and the docs (packed with the source, if there is anything else)
but didn't find the answer.
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?
G.
--
while (!asleep()) sheep++;
---------------------------- cut here ------------------------------
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Overwhelming DEBUG messages
2003-05-08 16:51 Overwhelming DEBUG messages SZŰCS Gábor <surrano@mailbox.hu>
@ 2003-05-08 18:06 ` Richard Huxton <dev@archonet.com>
2003-05-08 18:38 ` Re: Overwhelming DEBUG messages Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Richard Huxton @ 2003-05-08 18:06 UTC (permalink / raw)
To: SZŰCS Gábor <surrano@mailbox.hu>; 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Overwhelming DEBUG messages
2003-05-08 16:51 Overwhelming DEBUG messages SZŰCS Gábor <surrano@mailbox.hu>
2003-05-08 18:06 ` Re: Overwhelming DEBUG messages Richard Huxton <dev@archonet.com>
@ 2003-05-08 18:38 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-05-09 15:30 ` Re: Overwhelming DEBUG messages SZŰCS Gábor <surrano@mailbox.hu>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2003-05-08 18:38 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; +Cc: SZŰCS Gábor <surrano@mailbox.hu>; pgsql-sql
Richard Huxton <dev@archonet.com> writes:
> On Thursday 08 May 2003 5:51 pm, SZÛCS Gábor wrote:
>> Is there a way to configure postgres (including compile-time) not to log
>> such in the server log?
> 1. Go through the source and comment out "elog()" calls you don't want.
FWIW, those two messages have been reduced to level DEBUG2 in CVS tip...
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Overwhelming DEBUG messages
2003-05-08 16:51 Overwhelming DEBUG messages SZŰCS Gábor <surrano@mailbox.hu>
2003-05-08 18:06 ` Re: Overwhelming DEBUG messages Richard Huxton <dev@archonet.com>
2003-05-08 18:38 ` Re: Overwhelming DEBUG messages Tom Lane <tgl@sss.pgh.pa.us>
@ 2003-05-09 15:30 ` SZŰCS Gábor <surrano@mailbox.hu>
0 siblings, 0 replies; 4+ messages in thread
From: SZŰCS Gábor @ 2003-05-09 15:30 UTC (permalink / raw)
To: pgsql-sql
Dear Tom,
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
Sent: Thursday, May 08, 2003 8:38 PM
> FWIW, those two messages have been reduced to level DEBUG2 in CVS tip...
>
> regards, tom lane
>
Wow!
Is it safe/possible to patch this thing only from CVS? I don't wish to run a
devel build. Is there a short doc how to do it? I mean, I'm familiar with
CVS, but where is it and what files should I update?
G.
--
while (!asleep()) sheep++;
---------------------------- cut here ------------------------------
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-05-09 15:30 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-08 16:51 Overwhelming DEBUG messages SZŰCS Gábor <surrano@mailbox.hu>
2003-05-08 18:06 ` Richard Huxton <dev@archonet.com>
2003-05-08 18:38 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-05-09 15:30 ` SZŰCS Gábor <surrano@mailbox.hu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox