Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 394E89FC6ED for ; Fri, 1 Jun 2007 19:07:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 92556-03 for ; Fri, 1 Jun 2007 19:07:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sccrmhc13.comcast.net (sccrmhc13.comcast.net [63.240.77.83]) by postgresql.org (Postfix) with ESMTP id CEBB69FC32E for ; Fri, 1 Jun 2007 19:07:33 -0300 (ADT) Received: from [10.1.2.2] (c-75-71-235-22.hsd1.co.comcast.net[75.71.235.22]) by comcast.net (sccrmhc13) with ESMTP id <2007060122073201300ive9re>; Fri, 1 Jun 2007 22:07:32 +0000 From: "Ed L." To: pgsql-general@postgresql.org Subject: Re: query log corrupted-looking entries Date: Fri, 1 Jun 2007 16:07:25 -0600 User-Agent: KMail/1.9.5 Cc: Tom Lane , "George Pavlov" References: <29860.1161202644@sss.pgh.pa.us> <8C5B026B51B6854CBE88121DBF097A86CDD9A4@ehost010-33.exch010.intermedia.net> <24195.1180733773@sss.pgh.pa.us> In-Reply-To: <24195.1180733773@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200706011607.25894.pgsql@bluepolka.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/147 X-Sequence-Number: 114970 On Friday 01 June 2007 3:36 pm, Tom Lane wrote: > What *exactly* is the logging setup you guys use, and have you > tried alternatives? redirect_stderr = on # Enable capturing of stderr into log log_directory = '/users/.../logs' # Directory where log files are written log_filename = 'server_log.%a.%H:00-%H:59' # Log file name pattern. log_truncate_on_rotation = on # If on, any existing log file of the same log_rotation_age = 60min # Automatic rotation of logfiles will log_min_messages = notice # Values, in order of decreasing detail: log_connections = on log_disconnections = on log_duration = on log_line_prefix = '%m [%p] %u %r %d ' # Special values: log_statement = 'all' # none, ddl, mod, all I have not tried alternatives. The status quo is adequate. Ed