Log msg - Mailing list pgsql-admin

From Jie Liang
Subject Log msg
Date
Msg-id E7E213858379814A9AE48CA6754F5ECB1E1FBF@mail01.stbernard.com
Whole thread Raw
Responses Re: Log msg  (Gaetano Mendola <mendola@bigfoot.com>)
List 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

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: How do I grant access to entire database at once(schemas,tables,sequences,...)?
Next
From: "Gregory S. Williamson"
Date:
Subject: Re: Keep a user from creating tables ?