Hi everybody,
 I'm a hookie in this discussion list. Well, my intent is to get some informations about
PostgreSQL internals to work on a project. There is an excellent GPL'ed tool to work with Oracle
called TOra. It is as good as TOAD and SQL Navigator from Quest Software. As a meaning of
collaborate with the Open Source world i was thinking in port TOra to PostgreSQL. So, we'll have a
great database and a great tool to manage it. 
 Problem is: reading PostgreSQL documentation i didn't find any information about system tables
having runtime informations as Oracle has. And one of the great features of TOra is the
possibility to see in charts, in real-time, all kind of I/O operations, memory usage, queries
being executed, etc...
 If i didn't make myself clear, please point your browser to http://www.globecom.se/tora/
and see what i am suggesting to adapt to PostgreSQL.
 I hope i did not disturb anybody here.
 And, keep doing your great job. We are in debt with you guys!

Best regards,
 Daniel.

 

__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Mother's Day is May 12th!
http://shopping.yahoo.com

Fri, 10 May 2002 13:42:21 -0700 (PDT)
"Daniel H. F. e Silva" <dhfs@yahoo.com>
Monitoring backend activities
> Hi everybody,
>  I'm a hookie in this discussion list. Well, my intent is to get some
> informations about PostgreSQL internals to work on a project. There
> is an excellent GPL'ed tool to work with Oracle called TOra. It is as
> good as TOAD and SQL Navigator from Quest Software. As a meaning of
> collaborate with the Open Source world i was thinking in port TOra to
> PostgreSQL. So, we'll have a great database and a great tool to manage
> it.

I think that would be "rookie;" the term "hookie" refers to what you're 
"playing" if you skip school.

>  Problem is: reading PostgreSQL documentation i didn't find any
> information about system tables having runtime informations as Oracle
> has. And one of the great features of TOra is the possibility to see
> in charts, in real-time, all kind of I/O operations, memory usage,
> queries being executed, etc...

The only problem I see is that TOra already seems quite well supported for 
PostgreSQL.  I'm running it at the moment, and it works quite well...
--
(concatenate 'string "cbbrowne" "@cbbrowne.com")
http://www.cbbrowne.com/info/lsf.html
"Put simply, the antitrust laws in this country are basically a joke,
protecting us just enough to not have to re-name our park service the
Phillip Morris National Park Service." 
-- Courtney Love, Salon.com, June 14, 2000

-- 
(concatenate 'string "cbbrowne" "@ntlug.org")
http://www.cbbrowne.com/info/rdbms.html
Rules of the Evil Overlord  #220. "Whatever my one vulnerability is, I
will fake a  different one. For example, ordering  all mirrors removed
from the palace, screaming and flinching whenever someone accidentally
holds up a mirror, etc. In the climax when the hero whips out a mirror
and thrusts it at my face,  my reaction will be ``Hmm...I think I need
a shave.''"  <http://www.eviloverlord.com/>



-- 
(reverse (concatenate 'string "moc.enworbbc@" "sirhc"))
http://www.cbbrowne.com/info/linuxxian.html
As of next Monday, MACLISP will no longer support list structure.
Please downgrade your programs.
Fri, 10 May 2002 17:40:03 -0400
cbbrowne@cbbrowne.com
Re: Monitoring backend activities 