pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Log msg
3+ messages / 2 participants
[nested] [flat]

* Log msg
@ 2004-05-14 21:59 Jie Liang <jie@stbernard.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Jie Liang @ 2004-05-14 21:59 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin

How to config log file to log statement without CONTEXT stuff?
I want log query, but not the detail unless there is a problem, e.g.
Delete aaa from mytable where mysqlfunction(bbb);
I want log this statement, but not any CONTEXT inside mysqlfunction,
because it will easily filled up my disk if mytable have millions of
entries, meanwhile, the log file become useless.
But if I set log_statement = true, log file will log millions of
statement in mysqlfunction, but I set log_statement=false, log file
won't log query at all.
Simply say, I want log what I execute(my query), but not how execute
(process) .

Jie Liang
 



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Log msg
@ 2004-05-17 19:15 Jie Liang <jie@stbernard.com>
  2004-05-17 23:12 ` Re: Log msg Gaetano Mendola <mendola@bigfoot.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Jie Liang @ 2004-05-17 19:15 UTC (permalink / raw)
  To: Jie Liang <jie@stbernard.com>; Tom Lane <tgl@sss.pgh.pa.us>; Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin

Hi,All,


How to config log file to log statement without CONTEXT stuff? I want
log query, but not the detail unless there is a problem, 
e.g. Delete aaa from mytable where mysqlfunction(bbb); 
I want log this statement, 
but not any CONTEXT inside mysqlfunction, because it will easily filled
up my disk if mytable have millions of entries, meanwhile, the log file
become useless. 
But if I set log_statement = true, log file will log millions of
statement in mysqlfunction, but I set log_statement=false, log file
won't log query at all. 
Simply say, I want log what I execute(my query), but not how execute
(process) .

Jie Liang
 

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Log msg
  2004-05-17 19:15 Log msg Jie Liang <jie@stbernard.com>
@ 2004-05-17 23:12 ` Gaetano Mendola <mendola@bigfoot.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Gaetano Mendola @ 2004-05-17 23:12 UTC (permalink / raw)
  To: Jie Liang <jie@stbernard.com>

Jie Liang wrote:

> Hi,All,
> 
> 
> How to config log file to log statement without CONTEXT stuff? I want
> log query, but not the detail unless there is a problem, 
> e.g. Delete aaa from mytable where mysqlfunction(bbb); 
> I want log this statement, 
> but not any CONTEXT inside mysqlfunction, because it will easily filled
> up my disk if mytable have millions of entries, meanwhile, the log file
> become useless. 
> But if I set log_statement = true, log file will log millions of
> statement in mysqlfunction, but I set log_statement=false, log file
> won't log query at all. 
> Simply say, I want log what I execute(my query), but not how execute
> (process) .

Decrease the verbosity of your logs using:

log_error_verbosity = terse


Regards
Gaetano Mendola








^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-05-17 23:12 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-14 21:59 Log msg Jie Liang <jie@stbernard.com>
2004-05-17 19:15 Log msg Jie Liang <jie@stbernard.com>
2004-05-17 23:12 ` Gaetano Mendola <mendola@bigfoot.com>

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