Fw: LISTENING THE PORT
=?iso-8859-1?Q?F=E1bio_Santana?= <fabio3c@terra.com.br> writes:
I need to do a application that listen the port of Postgresql
and return all commands actually in process in Postgresql.
In 7.2 beta, try select * from pg_stat_activity (note you need
to enable collection of query strings...)
regards, tom lane
Import Notes
Reply to msg id not found: 000501c164963d8653d00dccb0c8@fabio3c1Reference msg id not found: 000501c164963d8653d00dccb0c8@fabio3c1
This page is with problems... (gborg.postgresql.org)
----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "F�bio Santana" <fabio3c@terra.com.br>
Cc: "Hackers Postgresql" <pgsql-hackers@postgresql.org>
Sent: Saturday, November 03, 2001 1:22 PM
Subject: Re: [HACKERS] LISTENING THE PORT
Show quoted text
Hello my friends! Sorry for my english!
I need to do a application that listen the port of Postgresql
and return all commands actually in process in Postgresql. Like
a monitor. I think that to do it i need to do a socket (sniffer)
and understand the structure for Postgresql protocol. Somebody
can help me?Have you tried pgmonitor at gborg.postgresql.org?
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly