Fw: LISTENING THE PORT

Started by Fábio Santanaabout 25 years ago2 messageshackers
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us
In reply to: Fábio Santana (#2)
Re: 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

#2Fábio Santana
fabio3c@terra.com.br

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