Re: Multiple Servers

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