Thread: Fw: LISTENING THE PORT

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


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

Fábio 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