Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 687669FBE22 for ; Wed, 18 Jul 2007 12:05:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96261-01-4 for ; Wed, 18 Jul 2007 12:05:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from lists.commandprompt.com (host-254.commandprompt.net [207.173.203.254]) by postgresql.org (Postfix) with ESMTP id 017BB9FBE11 for ; Wed, 18 Jul 2007 12:05:14 -0300 (ADT) Received: from perhan.alvh.no-ip.org (201-221-218-82.bk12-dsl.surnet.cl [201.221.218.82]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id l6IF53xw021721; Wed, 18 Jul 2007 08:05:07 -0700 Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id C41B747C48; Wed, 18 Jul 2007 11:05:01 -0400 (CLT) Date: Wed, 18 Jul 2007 11:05:01 -0400 From: Alvaro Herrera To: Michael Monnerie Cc: pgsql-admin@postgresql.org Subject: Re: syslog: log line length? Message-ID: <20070718150501.GD6651@alvh.no-ip.org> References: <200706292005.22378@zmi.at> <200707181256.58191@zmi.at> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <200707181256.58191@zmi.at> User-Agent: Mutt/1.5.16 (2007-06-11) X-Virus-Scanned: ClamAV 0.90.3/3693/Wed Jul 18 02:47:13 2007 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Wed, 18 Jul 2007 08:05:07 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/205 X-Sequence-Number: 26186 Michael Monnerie wrote: > On Freitag, 29. Juni 2007 Michael Monnerie wrote: > > I have most entries split over several lines: > > > > Jun 29 19:56:40 db.xxx.xxx postgres[10640]: [5-1] DB=XXX U=XXX > > H=1.1.1.1 16854186.2190 idleLOG: Verbindungsende: Sitzungszeit: > > 0:01:22.10 Jun 29 19:56:40 db.xxx.xxx postgres[10640]: [5-2] > > Benutzer=xxx Datenbank=xxxx Host=1.1.1.1 port=23640 > > > > Is it possible to tell postgres to split entries only after 200 > > chars, not already at about 80? 200 should fit most log lines into > > one entry. Postgres does not split entries. They are split by infelicities in the underlying facilities used (pipes). There's ongoing work to fix this problem. In the meantime, I think you could work around it by using syslog instead of redirect_stderr. -- Alvaro Herrera http://www.PlanetPostgreSQL.org/ "La primera ley de las demostraciones en vivo es: no trate de usar el sistema. Escriba un guión que no toque nada para no causar daños." (Jakob Nielsen)