Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2CBC49FB8A0 for ; Mon, 19 Feb 2007 11:35:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 12408-04-3 for ; Mon, 19 Feb 2007 11:34:39 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from exchange.corp.digonex.com (208-44-128-230.dia.static.qwest.net [208.44.128.230]) by postgresql.org (Postfix) with ESMTP id 5455D9FB8DD for ; Mon, 19 Feb 2007 11:34:42 -0400 (AST) Received: from [192.168.0.118] ([192.168.0.118]) by exchange.corp.digonex.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 19 Feb 2007 10:34:40 -0500 Message-ID: <45D9C390.6040907@musicrebellion.com> Date: Mon, 19 Feb 2007 10:34:40 -0500 From: Kris Kiger User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Built-in log rotation Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 19 Feb 2007 15:34:40.0622 (UTC) FILETIME=[789590E0:01C7543B] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200702/268 X-Sequence-Number: 24733 Greetings! I've been doing some research into log rotation software and ran into this, while looking through the postgres site: "There is a built-in log rotation program, which you can use by setting the configuration parameter redirect_stderr to true in postgresql.conf." http://www.postgresql.org/docs/8.1/interactive/logfile-maintenance.html My question is, how does it rotate logs? Does it perform a copy/truncate of the logfile? I know in older versions of postgres, if you tried to move the log file, and create one with the same name, the server wouldn't actually write to it without a restart...at least in linux it wouldn't. Do many of you use this mechanism? If not, what have you found to be a reliable solution? Thanks in advance for the info! - Kris