X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 24E5E9FA2E6 for ; Tue, 6 Jun 2006 09:45:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 86146-09 for ; Tue, 6 Jun 2006 09:45:34 -0300 (ADT) X-Greylist: delayed 00:09:20.697188 by SQLgrey- Received: from michael.eatserver.nl (michael.eatserver.nl [212.203.14.103]) by postgresql.org (Postfix) with ESMTP id D7B059F9316 for ; Tue, 6 Jun 2006 09:45:34 -0300 (ADT) Received: from dvipc (82-170-251-187.dsl.ip.tiscali.nl [82.170.251.187]) (authenticated bits=0) by michael.eatserver.nl (8.12.10/8.12.10/SuSE Linux 0.7) with ESMTP id k56Ca9ue028866 for ; Tue, 6 Jun 2006 14:36:09 +0200 From: "H.J. Sanders" To: Subject: logfile Date: Tue, 6 Jun 2006 14:37:11 +0200 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000C_01C68976.B217FAA0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869 Importance: Normal X-Virus-Scanned: by amavisd-new X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/23 X-Sequence-Number: 21985 This is a multi-part message in MIME format. ------=_NextPart_000_000C_01C68976.B217FAA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I assume I do not understand the manual right (or my kind of english). In PGSQL 7.4 I only want error situations in the logfile, and if an error occurs as much as possible information like e.g. the sql statement. I entered in postgresql.conf: client_min_messages = error log_min_messages = error log_error_verbosity = terse log_min_error_statement = error log_statement = true log_timestamp = true but now all sql statements are always logged. What did I do wrong? Can someone give the proper settings? Many thanks Henk Sanders ------=_NextPart_000_000C_01C68976.B217FAA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I assume I do not = understand=20 the manual right (or my kind of english).
 
In PGSQL 7.4 I only = want error=20 situations in the logfile, and if an error occurs as much as possible=20 information like e.g. the sql statement.
 
I entered in=20 postgresql.conf:
 
client_min_messages = =3D=20 error
log_min_messages = =3D=20 error
log_error_verbosity = =3D=20 terse
log_min_error_statement =3D=20 error
 
log_statement =3D=20 true
log_timestamp =3D=20 true
 
but now all sql = statements are=20 always logged.
 
What did I do = wrong? Can=20 someone give the proper settings?
 
Many = thanks
 
Henk=20 Sanders
 
 

------=_NextPart_000_000C_01C68976.B217FAA0--