Well, I wrote pgmonitor on gborg.postgresql.org, which is like top for
PostgreSQL, but is in TCL. It uses ps internally.
---
Shahbaz Chaudhary wrote:
Sorry, I don't think I made myself clear. I don't want to query the DB
every few seconds to get its current status. I want to keep an open an
open connection and have immediate access to all information like I have
when I set the debug level high and see everything going on inside the
DB right on my machine.
I guess think of it as a dashboard that constantly displays the db
status. Something like 'top' rather than 'ps -ef|grep .'.
As far as I understand, JDBC is just a mechanism to connect to a db,
execute queries, etc., not get this kind of info.
Shahbaz C.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On Behalf Of Bruce Momjian
Sent: Thursday, February 13, 2003 7:18 PM
To: Shahbaz Chaudhary
Cc: [EMAIL PROTECTED]
Subject: Re: [HACKERS] java access to the backend (non jdbc)?
Well, we have jdbc at jdbc.postgresql.org.
---
Shahbaz Chaudhary wrote:
Hi All,
I was wondering if there is a libq or libqxx type library written in
java. Even if it is done through jni. I would like to do some
experiments, perhaps make a utility that reads server information such
as currently executing query, current locks, amount of disk/ram taken
up
by pgsql. Basically some very useful information for admins. I've
forgotten most of C, C++ (from college days), but would love to try my
hand at such a utility...I'm sure there are others who would like to
use
java to access such a backend. Any pointers?
Shahbaz C.
---(end of
broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.| Newtown Square, Pennsylvania
19073
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.| Newtown Square, Pennsylvania 19073
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html