Hi,

I has a dinamic application, constructed on php, connecting in db postgres 7.2.
I would like monitor the all established connection. I want know whish command is running at moment.

Help, please !!!

Osvâneo A. Ferreira
osvaneo@ig.com








Hi,
 
I has a dinamic application, constructed on 
php, connecting in db postgres 7.2.
I would like monitor the all established 
connection. I want know whish command is running at moment.
 
Help, please !!!
 
Osvâneo A. Ferreira
osvaneo@ig.com
Tue, 5 Nov 2002 18:48:30 -0200
=?iso-8859-1?Q?Osv=E2neo_A._Ferreira?= <osvaneo@ig.com>
[ pgsql-monitoring ]
On Tue, Nov 05, 2002 at 06:48:30PM -0200, Osv?neo A.  Ferreira wrote:
> Hi,
> 
> I has a dinamic application, constructed on php, connecting in db postgres 7.2.
> I would like monitor the all established connection. I want know whish command is running at moment.
> 
> Help, please !!!

Check out pg_monitor (go to gborg.postgresql.org).  Also, this sort
of question belongs on -general.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


Thu, 7 Nov 2002 10:14:47 -0500
Andrew Sullivan <andrew@libertyrms.info>
Re: [ pgsql-monitoring ]
Turn on query monitoring in the postgresql.conf and then go:

select * from pg_stat_activity;

Chris
  -----Original Message-----
  From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Osvï¿½neo A. Ferreira
  Sent: Wednesday, 6 November 2002 4:49 AM
  To: pgsql-hackers@postgresql.org
  Subject: [HACKERS] [ pgsql-monitoring ]


  Hi,

  I has a dinamic application, constructed on php, connecting in db postgres
7.2.
  I would like monitor the all established connection. I want know whish
command is running at moment.

  Help, please !!!

  Osvï¿½neo A. Ferreira
  osvaneo@ig.com









Turn 
on query monitoring in the postgresql.conf and then go:
 
select 
* from pg_stat_activity;
 
Chris

-----Original Message-----From: 
  pgsql-hackers-owner@postgresql.org 
  [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Osvâneo A. 
  FerreiraSent: Wednesday, 6 November 2002 4:49 AMTo: 
  pgsql-hackers@postgresql.orgSubject: [HACKERS] [ pgsql-monitoring 
  ]
Hi,
 
I has a dinamic application, constructed on 
  php, connecting in db postgres 7.2.
I would like monitor the all established 
  connection. I want know whish command is running at moment.
 
Help, please !!!
 
Osvâneo A. Ferreira
osvaneo@ig.com
Fri, 8 Nov 2002 09:32:16 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: [ pgsql-monitoring ]