Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5KGX1a87619 for ; Wed, 20 Jun 2001 12:33:01 -0400 (EDT) (envelope-from pgsql-admin-owner@postgresql.org) Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5KA3Ea09986; Wed, 20 Jun 2001 06:03:14 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-31.mail.demon.net with esmtp (Exim 2.12 #1) id 15CeqV-000NmN-0V; Wed, 20 Jun 2001 11:04:23 +0100 Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id F3CDE1346D; Wed, 20 Jun 2001 11:02:37 +0100 (BST) Message-ID: <009101c0f970$220cee20$1001a8c0@archonet.com> From: "Richard Huxton" To: "Jie Liang" , "Tom Lane" Cc: , References: Subject: Re: [SQL] log file Date: Wed, 20 Jun 2001 11:02:32 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200106/132 X-Sequence-Number: 1689 From: "Jie Liang" > Tom, > > We turn on the log file by: > In file 'postgresql.conf' > syslog = 2 # range 0-2 > syslog_facility = 'LOCAL0' > syslog_ident = 'postgres' > > 1. It seems that postmaster writes stuff undef /db/pgsql/pg_xlog > (they are not text files). pg_xlog stuff is WAL related (Ch 9 Administrators guide) > 2. the log file I expected (I want log include SQL statement and ERROR) > Just have NOTICE and DEBUG info. I *think* you want DEBUG_PRINT_QUERY and its friends. See Ch 3.4.2 of the Administrators Guide. HTH - Richard Huxton