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/pgspyNot 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/