Re: Machine available for community use - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Machine available for community use
Date
Msg-id 20071102134956.0ebf9215@scratch
Whole thread Raw
In response to Re: Machine available for community use  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Machine available for community use
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Fri, 02 Nov 2007 15:37:17 -0400
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "Gavin M. Roy" <gavinmroy@gmail.com> writes:
> > Just a follow-up to note that Red Hat has graciously donated a 1
> > year RHEL subscription and myYearbook is paying Command Prompt to
> > setup the RHEL box for community use.
> 
> Sorry that Red Hat was so slow about that :-(
> 
> > [ various interesting questions snipped ]
> 
> > Should people only be able to run PostgreSQL in the context of their
> > own user?  Do we have experience with such setups in the past?  What
> > has worked well and what hasn't?
> 
> Yeah, I'd vote for people just building private PG installations in
> their own home directories.  I am not aware of any performance-testing
> reason why we'd want a shared installation, and given that people are
> likely to be testing many different code variants, a shared

The only caveat here is that our thinking was that the actual arrays
would be able to be re-provisioned all the time. E.g; test with RAID 10
with x stripe size, Software RAID 6, what is the real difference
between 28 spindles with RAID 5 versus 10?

> installation would be a management nightmare.  Also, with personal
> installations, nobody need have root privileges, which just seems
> like a real good idea.

No question.

Joshua D. Drake

> 
> I don't have any special insights about the other management issues
> you mentioned, but I'm sure someone does ...
> 
>             regards, tom lane
> 
> ---------------------------(end of
> broadcast)--------------------------- TIP 4: Have you searched our
> list archives?
> 
>                http://archives.postgresql.org
> 


- -- 
     === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/        UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHK412ATb/zqfZUUQRAg4eAJ0YubwkLQ3mU0st5jPhUnC6dWrqeACeMjQe
TFxunw+efuh3XNtMv+whKBI=
=RzC/
-----END PGP SIGNATURE-----

pgsql-hackers by date:

Previous
From: "Gevik Babakhani"
Date:
Subject: Continue [PATCHES] V0.1 patch for TODO Item: SQL-language reference parameters by name.
Next
From: Tom Lane
Date:
Subject: Re: Machine available for community use