pg_stat_activity IP address

From: "alexandre :: aldeia digital" <alepaes(at)aldeiadigital(dot)com(dot)br>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: pg_stat_activity IP address
Date: 2003-05-06 15:55:19
Message-ID: 42378.200.170.145.209.1052236519.squirrel@webmail.ad2.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I use pg_locks and pg_stat_activity to get the locked tables in
my database.

But I use the same user to all connections and pg_stat_activity
returns only the username.

I make a script that collect the IP address from ps and
concatenate with PID returned by pg_locks, but
is not usefull for a remote realtime statistic collect.

Thanks

Alexandre

Browse pgsql-sql by date

  From Date Subject
Next Message Randall Lucas 2003-05-06 16:01:20 UNIQUE boolean: only one row may be "true"
Previous Message Achilleus Mantzios 2003-05-06 15:01:04 Re: Problem with Attribute.