Re: pgqueryspy

From: Jeff Trout <threshar(at)torgo(dot)978(dot)org>
To: David Fetter <david(at)fetter(dot)org>
Cc: Christopher Kings-Lynne <chris(dot)kings-lynne(at)calorieking(dot)com>, PostgreSQL Advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: pgqueryspy
Date: 2006-06-27 18:28:24
Message-ID: E669B8FF-2C4D-4BA0-8212-220AD7193104@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy


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(at)jefftrout(dot)com>
http://www.dellsmartexitin.com/
http://www.stuarthamm.net/

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Robert Bernier 2006-06-27 23:56:54 Re: [Conference-attendees] Need Help with Equipment for Anniversary
Previous Message Neil Conway 2006-06-27 17:47:47 Re: pgqueryspy