|
Home > Archive > PostgreSQL Discussion > September 2005 > Need for java based web admin tool
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Need for java based web admin tool
|
|
|
| Hello,
I would like to admin PostgreSQL databases by using web interface which
runs in Java Application Server (Tomcat).
But I couldn't find any admin tool deployd as WAR file. Is there a java
based web admin or is it just a dream and there is no java analog for
phpPgAdmin?
Jaanus
| |
| Hannes Dorbath 2005-09-22, 8:24 pm |
| On 22.09.2005 20:41, Jobu wrote:
> Is there a java based web admin or is it just a dream and there is no java analog for phpPgAdmin?
There is none to my knowledge. Java client side frontends such as Aqua
Data Studio (http://www.aquafold.com/) exist..
> ..which runs in Java Application Server (Tomcat).
So if you have apache running anyway, why not load up mod_php, drop
phpPgAdmin in a dir and be happy? Does it necessarily have to be
webbased? IMHO it's a pain to administrate a DBMS over a webfront.
If it just needs to work over HTTP, there are frontends that can tunnel
over a HTTP connection. EMS Postgres Manager is one of them and the lite
versions are free.
http://www.sqlmanager.net
--
Regards,
Hannes Dorbath
| |
|
| I would like to install to client machine only Tomcat (You can't use
php in Tomcat).
And I would like to leave postgres ports closed, so HTTP tunneling is
not a good solution...
But EMS Postgres Manager seams to be a nice tool, so thanks anyway.
Jaanus Hansen
| |
| Hannes Dorbath 2005-09-23, 8:23 pm |
| > I would like to install to client machine only Tomcat (You can't use php in Tomcat).
I might be wrong, but isn't it a common setup to have an apache running
in front of tomcat and having apache passing all JSP requests to tomcat ?
> And I would like to leave postgres ports closed, so HTTP tunneling is not a good solution...
That's what EMS PGM's HTTP tunneling is all about. You put a PHP proxy
script on your server, it uses Unix sockets to connect to the local PG
server and the EMS frontend calls that script over HTTP -- and it works
very well.
> But EMS Postgres Manager seams to be a nice tool, so thanks anyway.
IMHO the best win32 frontend out there.
--
Regards,
Hannes Dorbath
| |
| Andrus 2005-09-27, 11:23 am |
| > If it just needs to work over HTTP, there are frontends that can tunnel
> over a HTTP connection. EMS Postgres Manager is one of them and the lite
> versions are free.
>
> http://www.sqlmanager.net
Hannes,
How to edit the table data with free version ( addd, delete, filter rows)?
pgAdmin allows to edit data in table form but I havent found any such
possibility in SQL Manager.
Andrus.
|
|
|
|
|