I honestly like Postgres more than MySQL, but having users that can either
create an unlimited amount of databases, or can only play with pre-created
tables really isn't ideal.
I am biased as I started my life with databases on MySQL, but to me, the
way their user system is setup makes more sense. Though I know most think
the opposite.
Chris
At 05:42 PM 8/20/2001 -0700, you wrote:
>On Mon, Aug 20, 2001 at 01:10:28PM -0600, Chris Cameron wrote:
> > I have a client who's looking to start using PostgreSQL. Unlike
> > MySQL, Postgres doesn't have the best (in my opionion) setup for
> > letting multiple users develop using the same server.
>
>Why don't you think so?
>
>We have a development system and a production system. We run a
>single cluster on the development box, and each developer has a
>PostgreSQL user id that has create DB but not create user
>permissions. They happily whale away without any obvious problems.
>
>Now, if PostgreSQL were unreliable and we had to stop and start it
>(like we did with Informix) a lot, then I could see running seperate
>clusters on one machine, so one could be bounced without affecting
>the others. It's not that hard to do, but again--why would you want
>to?
>
> -crl
>--
>Chad R. Larson (CRL22) chad@eldocomp.com
> Eldorado Computing, Inc. 602-604-3100
> 5353 North 16th Street, Suite 400
> Phoenix, Arizona 85016-3228