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) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
