pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedUser administration tool
8+ messages / 4 participants
[nested] [flat]
* User administration tool
@ 2001-03-30 03:12 Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 8+ messages in thread
From: Bruce Momjian @ 2001-03-30 03:12 UTC (permalink / raw)
To: PostgreSQL-development <pgsql-hackers@postgreSQL.org>
[ Replies set to hackers.]
I have started coding a user/group administration tool that allows you
to add/modify/delete users and groups. I should have something working
in a week. I will look similar to my pgmonitor tool.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [ADMIN] User administration tool
@ 2001-03-30 15:24 Peter Eisentraut <peter_e@gmx.net>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 8+ messages in thread
From: Peter Eisentraut @ 2001-03-30 15:24 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: PostgreSQL-development <pgsql-hackers@postgreSQL.org>
Bruce Momjian writes:
> I have started coding a user/group administration tool that allows you
> to add/modify/delete users and groups. I should have something working
> in a week. I will look similar to my pgmonitor tool.
Pgaccess already does part of this. If you're going to write it in Tcl/Tk
anyway, I think you might as well integrate it there.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: User administration tool
@ 2001-03-30 15:48 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 8+ messages in thread
From: Bruce Momjian @ 2001-03-30 15:48 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: PostgreSQL-development <pgsql-hackers@postgreSQL.org>
> Bruce Momjian writes:
>
> > I have started coding a user/group administration tool that allows you
> > to add/modify/delete users and groups. I should have something working
> > in a week. I will look similar to my pgmonitor tool.
>
> Pgaccess already does part of this. If you're going to write it in Tcl/Tk
> anyway, I think you might as well integrate it there.
Wow, I see. I never suspected it did that too. :-) Seems I don't need
to write anything, except perhaps add group capabilities to pgaccess.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [ADMIN] User administration tool
@ 2001-03-30 19:20 Jan T. Kim <kim@inb.mu-luebeck.de>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 8+ messages in thread
From: Jan T. Kim @ 2001-03-30 19:20 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Peter Eisentraut <peter_e@gmx.net>; PostgreSQL-development <pgsql-hackers@postgresql.org>
On Fri, Mar 30, 2001 at 10:48:54AM -0500, Bruce Momjian wrote:
> > Bruce Momjian writes:
> >
> > > I have started coding a user/group administration tool that allows you
> > > to add/modify/delete users and groups. I should have something working
> > > in a week. I will look similar to my pgmonitor tool.
> >
> > Pgaccess already does part of this. If you're going to write it in Tcl/Tk
> > anyway, I think you might as well integrate it there.
>
> Wow, I see. I never suspected it did that too. :-) Seems I don't need
> to write anything, except perhaps add group capabilities to pgaccess.
Isn't phpPgAdmin yet another tool of this type? I haven't tried it myself,
(no need, myself being the only user...) but the web page
(http://www.greatbridge.org/project/phppgadmin/projdisplay.php) says:
Features include:
* create and drop databases
* create, copy, drop and alter
tables/views/sequences/functions/indicies/triggers
* edit and add fields (to the extent Postgres allows)
* execute any SQL-statement, even batch-queries
* manage primary and unique keys
* create and read dumps of tables
* administer one single database
* administer multiple servers
* administer postgres users and groups
Greetinx, Jan
--
+- Jan T. Kim -------------------------------------------------------+
| *NEW* --> email: kim@inb.mu-luebeck.de |
| *NEW* --> WWW: http://www.inb.mu-luebeck.de/staff/kim.html |
*-----=< hierarchical systems are for files, not for humans >=-----*
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [ADMIN] User administration tool
@ 2001-03-30 19:23 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Jan T. Kim <kim@inb.mu-luebeck.de>
0 siblings, 1 reply; 8+ messages in thread
From: Bruce Momjian @ 2001-03-30 19:23 UTC (permalink / raw)
To: Jan T. Kim <kim@inb.mu-luebeck.de>; +Cc: Peter Eisentraut <peter_e@gmx.net>; PostgreSQL-development <pgsql-hackers@postgresql.org>
> > Wow, I see. I never suspected it did that too. :-) Seems I don't need
> > to write anything, except perhaps add group capabilities to pgaccess.
>
> Isn't phpPgAdmin yet another tool of this type? I haven't tried it myself,
> (no need, myself being the only user...) but the web page
> (http://www.greatbridge.org/project/phppgadmin/projdisplay.php) says:
Yes, it is. Some people prefer a non-web interaface.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [HACKERS] Re: [ADMIN] User administration tool
@ 2001-03-30 19:44 The Hermit Hacker <scrappy@hub.org>
parent: Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 8+ messages in thread
From: The Hermit Hacker @ 2001-03-30 19:44 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Jan T. Kim <kim@inb.mu-luebeck.de>; pgsql-interfaces; Peter Eisentraut <peter_e@gmx.net>
<moved to -interfaces, where it belongs ... >
On Fri, 30 Mar 2001, Bruce Momjian wrote:
> > > Wow, I see. I never suspected it did that too. :-) Seems I don't need
> > > to write anything, except perhaps add group capabilities to pgaccess.
> >
> > Isn't phpPgAdmin yet another tool of this type? I haven't tried it myself,
> > (no need, myself being the only user...) but the web page
> > (http://www.greatbridge.org/project/phppgadmin/projdisplay.php) says:
>
> Yes, it is. Some people prefer a non-web interaface.
I could understand this sentiment if you were doing something from the
command line, but if you are doing an interface in tcl/tk, I think a web
interface fairs better ...
tcl/tk, you have to be on the same machine or risk "network problems"
losing your link ... web, its a stateless connection, so each time you do
something, it re-establishes the connection and performs the operation ...
IMHO, a web interface will always be appropriate in a network environment,
unless you have the luxury of sitting on the same machine you are running
the X app (tcl/tk) on ... *shrug*
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [HACKERS] Re: [ADMIN] User administration tool
@ 2001-03-30 21:45 Peter Eisentraut <peter_e@gmx.net>
parent: The Hermit Hacker <scrappy@hub.org>
0 siblings, 1 reply; 8+ messages in thread
From: Peter Eisentraut @ 2001-03-30 21:45 UTC (permalink / raw)
To: The Hermit Hacker <scrappy@hub.org>; +Cc: Bruce Momjian <pgman@candle.pha.pa.us>; Jan T. Kim <kim@inb.mu-luebeck.de>; pgsql-interfaces
The Hermit Hacker writes:
> > Yes, it is. Some people prefer a non-web interaface.
>
> I could understand this sentiment if you were doing something from the
> command line, but if you are doing an interface in tcl/tk, I think a web
> interface fairs better ...
>
> tcl/tk, you have to be on the same machine or risk "network problems"
> losing your link ...
A Tcl/Tk applications doesn't risk any more network problems than any
other interface to the database, unless that interface is run on the same
machine as the database, which is by no means a given.
If you are under a constant risk of "network problems" then you better fix
your network. A web interface won't magically bridge network problems.
> web, its a stateless connection, so each time you do something, it
> re-establishes the connection and performs the operation ...
It makes the whole thing slower and won't let you preserve state. This
seems to be a disadvantage to me.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: [HACKERS] Re: [ADMIN] User administration tool
@ 2001-03-30 21:48 The Hermit Hacker <scrappy@hub.org>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 8+ messages in thread
From: The Hermit Hacker @ 2001-03-30 21:48 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: Bruce Momjian <pgman@candle.pha.pa.us>; Jan T. Kim <kim@inb.mu-luebeck.de>; pgsql-interfaces
On Fri, 30 Mar 2001, Peter Eisentraut wrote:
> The Hermit Hacker writes:
>
> > > Yes, it is. Some people prefer a non-web interaface.
> >
> > I could understand this sentiment if you were doing something from the
> > command line, but if you are doing an interface in tcl/tk, I think a web
> > interface fairs better ...
> >
> > tcl/tk, you have to be on the same machine or risk "network problems"
> > losing your link ...
>
> A Tcl/Tk applications doesn't risk any more network problems than any
> other interface to the database, unless that interface is run on the same
> machine as the database, which is by no means a given.
>
> If you are under a constant risk of "network problems" then you better fix
> your network. A web interface won't magically bridge network problems.
my "network problem" happens to be a database server half way across the
country from me ... running a tcl/tk interface would be useless, while a
web interface does exactly what I need ...
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2001-03-30 21:48 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-30 03:12 User administration tool Bruce Momjian <pgman@candle.pha.pa.us>
2001-03-30 15:24 ` Peter Eisentraut <peter_e@gmx.net>
2001-03-30 15:48 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-03-30 19:20 ` Jan T. Kim <kim@inb.mu-luebeck.de>
2001-03-30 19:23 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-03-30 19:44 ` The Hermit Hacker <scrappy@hub.org>
2001-03-30 21:45 ` Peter Eisentraut <peter_e@gmx.net>
2001-03-30 21:48 ` The Hermit Hacker <scrappy@hub.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox