From: alexandre :: aldeia digital <alepaes@aldeiadigital.com.br>
To: pgsql-sql@postgresql.org
Subject: pg_stat_activity IP address
Date: Tue, 6 May 2003 12:55:19 -0300 (BRT)
Message-ID: <42378.200.170.145.209.1052236519.squirrel@webmail.ad2.com.br> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: alepaes@aldeiadigital.com.br
Subject: Re: pg_stat_activity IP address
In-Reply-To: <42378.200.170.145.209.1052236519.squirrel@webmail.ad2.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox