Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 90E162E3963 for ; Thu, 24 Jan 2008 16:53:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 16418-02-9 for ; Thu, 24 Jan 2008 16:53:52 -0400 (AST) Received: from sd-2317.dedibox.fr (sd-2317.dedibox.fr [88.191.17.192]) by postgresql.org (Postfix) with ESMTP id D70DF2E4125 for ; Thu, 24 Jan 2008 15:56:37 -0400 (AST) Received: from [192.168.10.1] (ASte-Genev-Bois-153-1-15-217.w83-112.abo.wanadoo.fr [83.112.195.217]) by sd-2317.dedibox.fr (Postfix) with ESMTP id E30A82000; Thu, 24 Jan 2008 20:56:30 +0100 (CET) Message-ID: <4798ED6D.4080701@lelarge.info> Date: Thu, 24 Jan 2008 20:56:29 +0100 From: Guillaume Lelarge User-Agent: Thunderbird 2.0.0.9 (X11/20071112) MIME-Version: 1.0 To: Chris Hoover CC: "pgsql-admin@postgresql.org Admin" Subject: Re: 8.3 Logging Question References: <1d219a6f0801241031p4faa7b3cr2260f97e76bc71e0@mail.gmail.com> In-Reply-To: <1d219a6f0801241031p4faa7b3cr2260f97e76bc71e0@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/235 X-Sequence-Number: 28009 Chris Hoover wrote: > I'm running PG 8.3rc2 to start testing it out, and really like how it is > preforming for me so far. However, I have one question on the logging. > I am trying to use syslog and csvlog to log all sql. This seems to work > great except that for every log rotation postgres does, I get a .csv log > file that grows and a 0 byte .log file. Since I'm not logging to > stderr, why is the .log file being created, and how do I turn that off? > Yes, I have the same issue. I don't think you can do something to stop this behaviour. postmaster process creates the directory if not present, then tries to create a file in it, and finally launches the syslogger subprocess. The file it creates is your .log file. I'm not sure why it creates a .log file. Perhaps the postmaster process has no idea at this time that the DBA wants csvlog files. Anyways, you'll only have one .log file because rotation function takes care of the log_destination. > [...] > log_destination = 'syslog,csvlog' # Valid values are > combinations of This is kind of strange. It should be syslog or csvlog. It shouldn't be both of them. Or am I wrong ? Regards. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com