Re: Postgres setup question - Mailing list pgsql-admin

From Robert Treat
Subject Re: Postgres setup question
Date
Msg-id 200409210220.35236.xzilla@users.sourceforge.net
Whole thread Raw
In response to Postgres setup question  (rjyoung@scs.carleton.ca)
List pgsql-admin
On Monday 20 September 2004 12:04, rjyoung@scs.carleton.ca wrote:
> Hi there,
>
> I've been looking into configuring Postgres for a small/medium sized group
> of users for a local computer science society.  We want to give each user
> their own database, and have it administratable via the Usermin web
> interface (some people will be fairly green, and we felt Usermin gives a
> decent gui to get your legs in postgres (as well as other things the
> society is going to offer.))  Now, the problem is, Usermin has to be
> configured to connect to the template1 database by default (or some other
> database,) and we want the user to connect to use the database with the
> same name as their user account name.
>
> I am thinking of simply allowing users to connect the template1 database
> and the database with their name.  Would this be adequate, or will I have
> to make sure that only the postgres user can edit the template1 database?
> I want to make sure the normal users cannot edit the template1 database.
>

I usually hate posts like this, but I am pretty sure phppgadmin will do what
you want.

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: unique constraints on foreign keys
Next
From: Robert Treat
Date:
Subject: Re: The link for the Beta 2 Windows version of 8.0 is not working