From: | Chris Cameron <chris(at)upnix(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Multiple Servers |
Date: | 2001-08-21 01:08:29 |
Message-ID: | 5.1.0.14.0.20010820190226.03631f88@mail.upnix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)eldocomp(dot)com
> Eldorado Computing, Inc. 602-604-3100
> 5353 North 16th Street, Suite 400
> Phoenix, Arizona 85016-3228
From | Date | Subject | |
---|---|---|---|
Next Message | C. Bensend | 2001-08-21 01:48:44 | Re: Multiple Servers |
Previous Message | Tom Lane | 2001-08-21 00:41:39 | Re: Multiple Servers |