X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AC245567D3 for ; Mon, 14 Mar 2005 18:04:26 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07844-06 for ; Mon, 14 Mar 2005 18:04:16 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 6512F56807 for ; Mon, 14 Mar 2005 18:04:09 +0000 (GMT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 14 Mar 2005 12:04:10 -0600 Subject: Re: Log to Syslog or rotatelogs? Advice Please From: Scott Marlowe To: David Wagoner Cc: PgSQL Admin In-Reply-To: <3085811c05031406373a8826e6@mail.gmail.com> References: <3085811c05031406373a8826e6@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Message-Id: <1110823449.28555.59.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 14 Mar 2005 12:04:10 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/214 X-Sequence-Number: 16712 On Mon, 2005-03-14 at 08:37, David Wagoner wrote: > Postgres 7.3.9 on RH Linux... >=20 > Setting up new production server-=20 >=20 > Is it better to send the postmaster log to Syslog or to rotatelogs? That really depends more on your production environment than any thing else. I use apache's rotatelogs with my systems, because the only "log server" we have is for application logging. If you use syslogd, be sure read the man page, where they mention the - character: "The - may only be used to prefix a filename if you want to omit sync=E2=80=99ing the file after every write to it." Which is very important if you want postgresql to keep running speedily.