Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 709A69FB4E7 for ; Fri, 20 Jul 2007 17:07:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 05805-01 for ; Fri, 20 Jul 2007 17:07:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from power2u.goelsen.net (mail.goelsen.net [195.202.170.130]) by postgresql.org (Postfix) with ESMTP id 696089FC10E for ; Fri, 20 Jul 2007 17:07:25 -0300 (ADT) X-Envelope-From: michael.monnerie@it-management.at Received: from localhost (localhost [127.0.0.1]) by power2u.goelsen.net (Postfix) with ESMTP id 796778300D for ; Fri, 20 Jul 2007 22:07:22 +0200 (CEST) Received: from power2u.goelsen.net ([127.0.0.1]) by localhost (power2u.goelsen.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22302-05 for ; Fri, 20 Jul 2007 22:07:17 +0200 (CEST) X-Envelope-From: michael.monnerie@it-management.at Received: from mailsrv.i.zmi.at (h081217116113.dyn.cm.kabsi.at [81.217.116.113]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "mailsrv.i.zmi.at", Issuer "mailsrv.i.zmi.at" (not verified)) by power2u.goelsen.net (Postfix) with ESMTP id A011882EAB for ; Fri, 20 Jul 2007 22:07:17 +0200 (CEST) From: Michael Monnerie Organization: it-management http://it-management.at To: pgsql-admin@postgresql.org Subject: Re: syslog: log line length? Date: Fri, 20 Jul 2007 22:07:10 +0200 User-Agent: KMail/1.9.7 References: <200706292005.22378@zmi.at> <200707181256.58191@zmi.at> <20070718150501.GD6651@alvh.no-ip.org> In-Reply-To: <20070718150501.GD6651@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart9340569.lktfZbtmO1"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200707202207.15735@zmi.at> X-Virus-Scanned: amavisd-new at goelsen.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/237 X-Sequence-Number: 26218 --nextPart9340569.lktfZbtmO1 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On Mittwoch, 18. Juli 2007 Alvaro Herrera wrote: > Postgres does not split entries. =A0They are split by infelicities in > the underlying facilities used (pipes). =A0There's ongoing work to fix > this problem. =A0In the meantime, I think you could work around it by > using syslog instead of redirect_stderr. This *is* syslog. Can I specify line length there? This is one log entry (from a long query) split over 2374 lines: Jul 20 14:13:55 db1.zmi.at postgres[9596]: [3-1] DB=3Dbayes_db U=3Dbayes_se= rver_33 H=3D123.132.123.123 42a0a3f9.237c SELECT:LOG: Dauer: 7420.180 ms = Anweisung: select put_tokens(1, Jul 20 14:13:55 db1.zmi.at postgres[9596]: [3-2] '{"\\\\000\\\\003\\\\335\= \\\131\\\\354","\\\\000\\\\013\\\\067\\\\227\\\\250","\\\\000\\\\015\\\\012= \\\\267\\\\317","\\\\000\\\ [snip] Jul 20 14:13:56 db1.zmi.at postgres[9596]: [3-2372] \\377\\\\333\\\\246\\\\= 200\\\\040","\\\\377\\\\334\\\\047\\\\144\\\\105","\\\\377\\\\363\\\\043\\\= \077\\\\354","\\\\377\\\\370\\ Jul 20 14:13:56 db1.zmi.at postgres[9596]: [3-2373] \\066\\\\152\\\\106","\= \\\377\\\\376\\\\045\\\\100\\\\172"}', Jul 20 14:13:56 db1.zmi.at postgres[9596]: [3-2374] = 0, 1, 1184933549) And where could I configure to have english, not german, postgres logs? mfg zmi =2D-=20 // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: EA39 8918 EDFF 0A68 ACFB 11B7 BA2D 060F 1C6F E6B0 // Keyserver: www.keyserver.net Key-ID: 1C6FE6B0 --nextPart9340569.lktfZbtmO1 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQBGoRXzui0GDxxv5rARAsn4AJ9tt2n+2Y10yXm44+O2DWKtAYYTwQCg2zfg K0B7KPyN9oTECJGWXsNlHI4= =ZWfd -----END PGP SIGNATURE----- --nextPart9340569.lktfZbtmO1--