On Jun 27, 2006, at 1:19 PM, David Fetter wrote:
> On Tue, Jun 27, 2006 at 04:47:24PM +0800, Christopher Kings-Lynne
> wrote:
>> This seems new:
>>
>> http://dotnot.org/blog/archives/2006/02/22/spying-on-postgresql/
>
> Have you used it? Does it work? Is it as non-invasive as the author
> claims?
>
I wrote a tool a year or two ago that does this sort of thing.
Uses libpcap to find PG packets and decodes v2 and v3 protocols.
http://pgfoundry.org/projects/pgspy
Not the best code, but it worked super good for my uses. Can also
provide TPS information as well.
--
Jeff Trout <jeff@jefftrout.com>
http://www.dellsmartexitin.com/http://www.stuarthamm.net/