Sunday, May 13, 2012

Hyperic, browse PostgreSQL DB

look in C:\pierre\hypericserver\server-4.6.5-EE\conf\hq-server.conf


To browse the DB:
start HQ Server


Welcome to psql 8.2.5, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

Warning: Console code page (437) differs from Windows code page (1252)
8-bit characters may not work correctly. See psql reference
page "Notes for Windows users" for details.

Useful commands

\h help with SQL commands
? help with psql commands
\du list roles/users
\l list databases
\c to choose a database
\d to list tables once in a database
\q quit

I do:

\c hqdb
and I get plenty of eam_", hq_metric* and qrtz* tables. It looks quite complex.

select * from eam_platform;
select * from eam_resource;

here the manual of psql

If you need a GUI, here a lost of GUI who support PostgreSQL

I have installed Squirrel, and copied postgresql-7.4.3.jar from Hyperic to C:\pierre\squirrel\lib (requires restart). It connects without problem (use jdbc:postgresql:// hqadmin hqadmin), but then I am lost in this UI.

No comments: