From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Organization: Dynacom Tankers Mgmt
To: pgsql-admin@postgresql.org
Subject: severely wierd problem & PgSQL log analyzer
Date: Mon, 1 Mar 2010 17:31:15 +0200
User-Agent: KMail/1.9.7
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <201003011731.15724.achill@matrix.gatewaynet.com>

Hi,
i am facing a very wierd situation, a piece of java code seems correct, however *some* times a connection instead of being rollbacked gets commited.
(which has driven me nuts). So what i did, is replicate the problem with full logging enabled from java, in order to know at any point
in the code against which postgres pid backend i am running against.
At the same time i had full logging enabled in postgresql 8.3 and i tried to trace the exact backend which resulted in commit.
(i try to replicate the problem by hitting the reload button in firefox).
However that gives me about over 160 instances of the program, making difficult to put together all those sessions from the logs,
and it seems i cannot see whats happening unless i have a handy tool that can extract info from the logs and present it in a human way.

Any suggestions for a good pgsql log analyzer? i am currently struggling with http://pgfouine.projects.postgresql.org/tutorial.html
(having failed with http://bucardo.org/wiki/Pgsi which wants only syslog)
-- 
Achilleas Mantzios