Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id ACC392E3093 for ; Thu, 24 Jan 2008 21:58:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 32005-03-8 for ; Thu, 24 Jan 2008 21:58:50 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id ACD872E327E for ; Thu, 24 Jan 2008 20:36:45 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m0P0ah5q017906; Thu, 24 Jan 2008 19:36:43 -0500 (EST) To: "Chris Hoover" cc: "pgsql-admin@postgresql.org Admin" Subject: Re: 8.3 Logging Question In-reply-to: <1d219a6f0801241611k2521da69j706f18d032f5a104@mail.gmail.com> References: <1d219a6f0801241031p4faa7b3cr2260f97e76bc71e0@mail.gmail.com> <16614.1201214339@sss.pgh.pa.us> <1d219a6f0801241611k2521da69j706f18d032f5a104@mail.gmail.com> Comments: In-reply-to "Chris Hoover" message dated "Thu, 24 Jan 2008 19:11:59 -0500" Date: Thu, 24 Jan 2008 19:36:43 -0500 Message-ID: <17905.1201221403@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/240 X-Sequence-Number: 28014 "Chris Hoover" writes: > On Jan 24, 2008 5:38 PM, Tom Lane wrote: >> The .log file is to catch any non-csv-format data that comes down the >> pipe. You can't turn it off. > What type of data would you expect this to be? Any bit of code that doesn't know about elog, for instance --- shared library linking problems from the dynamic loader --- complaints from perl, python, or other libraries you might have loaded into the backend --- corrupted-memory messages out of glibc (malloc) --- yadda yadda yadda One of the main strikes against syslog logging has always been that it fails to capture this type of stuff. You don't realize you need this until you need it, but then you really do. regards, tom lane