Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2554D9FB62E for ; Tue, 19 Jun 2007 11:31:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 73811-02 for ; Tue, 19 Jun 2007 11:31:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 7C3469FB623 for ; Tue, 19 Jun 2007 11:31:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from pjetlic.mobart.hr (pjetlic.mobart.hr [80.80.51.10]) by svr4.postgresql.org (Postfix) with ESMTP id 444365AF88C for ; Tue, 19 Jun 2007 14:31:34 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by pjetlic.mobart.hr (Postfix) with ESMTP id D10FD3C905 for ; Tue, 19 Jun 2007 16:31:14 +0200 (CEST) Received: from pjetlic.mobart.hr ([127.0.0.1]) by localhost (pjetlic [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 28838-01-2 for ; Tue, 19 Jun 2007 16:31:12 +0200 (CEST) Received: from mike.mobart.hr (mike.mobart.hr [192.168.10.94]) (using SSLv3 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by pjetlic.mobart.hr (Postfix) with ESMTP id B619F3C903 for ; Tue, 19 Jun 2007 16:31:12 +0200 (CEST) Subject: Postgres8.2 - turning off BINGLOG/PARSELOG From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: pgsql-admin@postgresql.org Content-Type: text/plain Organization: Mob-Art d.o.o. Date: Tue, 19 Jun 2007 16:31:12 +0200 Message-Id: <1182263472.13561.43.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.6.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by OpenSource AV+AS Mail Server X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/170 X-Sequence-Number: 25838 I'm finaly switching to 8.2. I notice that ugly 'feature' from pg8.1 has been fixed: logging the parametars of prepared statements. It's a bit ugly, but it's there :) But now in my log i have BINDLOG, PARSELOG and others, and my log looks realy cloged. Here is an example. I'm calling the 'create_mo_sms_message' function via JDBC, and this is the log entry: 2007-06-19 16:22:15.553 CEST [4596] BINDLOG: duration: 0.023 ms bind S_1: BEGIN 2007-06-19 16:22:15.553 CEST [4596] BEGINLOG: duration: 0.010 ms execute S_1: BEGIN 2007-06-19 16:22:15.553 CEST [4596] PARSELOG: duration: 0.165 ms parse : select * from create_mo_sms_message($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11) as result 2007-06-19 16:22:15.553 CEST [4596] BINDLOG: duration: 0.292 ms bind : select * from create_mo_sms_message($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11) as result 2007-06-19 16:22:15.553 CEST [4596] BINDDETAIL: parameters: $1 = NULL, $2 = 'a9369fa8-2bd9-41f0-a325-cd0fe62fbe46', $3 = '+38598111111', $4 = 'PULITZER-1', $5 = 'memo Ovo je moja mala probetina...', $6 = '2007-06-19 14:22:15.547', $7 = NULL, $8 = NULL, $9 = '127.0.0.1', $10 = 'tele2', $11 = NULL 2007-06-19 16:22:15.554 CEST [4596] SELECTNOTICE: __internal__determine_operator_id: Operator_mark >tele2< does not exists! 2007-06-19 16:22:15.554 CEST [4596] SELECTCONTEXT: PL/pgSQL function "create_mo_sms_message" line 24 at assignment 2007-06-19 16:22:15.554 CEST [4596] SELECTNOTICE: CREATE_MO: Operator_id could not be guessed... 2007-06-19 16:22:15.554 CEST [4596] SELECTLOG: duration: 0.599 ms execute : select * from create_mo_sms_message($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11) as result 2007-06-19 16:22:15.554 CEST [4596] SELECTDETAIL: parameters: $1 = NULL, $2 = 'a9369fa8-2bd9-41f0-a325-cd0fe62fbe46', $3 = '+38598111111', $4 = 'PULITZER-1', $5 = 'memo Ovo je moja mala probetina...', $6 = '2007-06-19 14:22:15.547', $7 = NULL, $8 = NULL, $9 = '127.0.0.1', $10 = 'tele2', $11 = NULL 2007-06-19 16:22:15.555 CEST [4596] BINDLOG: duration: 0.027 ms bind S_2: COMMIT 2007-06-19 16:22:15.556 CEST [4596] COMMITLOG: duration: 0.029 ms execute S_2: COMMIT These are the settings from postgresql.conf, concerning loging: log_min_messages = info log_min_duration_stateme log_error_verbosity = defaultnt = 0 debug_print_parse = off debug_print_rewritten = off debug_pretty_print = off log_line_prefix = '%m [%p] <%d> %i' Is there a way to turn off these PARSELOG and BINDLOG messages? I realy need only the SELECTLOG (and SELECTDETAIL because there are the actuall parametars)? Tia, Mario