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