Re: java access to the backend (non jdbc)? - Mailing list pgsql-hackers
From | Bruce Momjian |
---|---|
Subject | Re: java access to the backend (non jdbc)? |
Date | |
Msg-id | 200302140038.h1E0cJx03351@candle.pha.pa.us Whole thread Raw |
In response to | Re: java access to the backend (non jdbc)? ("Shahbaz Chaudhary" <chaudhar@umich.edu>) |
List | pgsql-hackers |
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: pgsql-hackers-owner@postgresql.org > [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Bruce Momjian > Sent: Thursday, February 13, 2003 7:18 PM > To: Shahbaz Chaudhary > Cc: pgsql-hackers@postgresql.org > 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 > pgman@candle.pha.pa.us | (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 pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073
pgsql-hackers by date: