From: Andrew McMillan <andrew@catalyst.net.nz>
To: Greg Smith <gsmith@gregsmith.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Best OS for Postgres 8.2
Date: Sun, 13 May 2007 18:34:20 +1200
Message-ID: <1179038060.4722.43.camel@hippy.mcmillan.net.nz> (raw)
In-Reply-To: <Pine.GSO.4.64.0705082302170.29385@westnet.com>
References: <1178574927.533849.90730@e51g2000hsg.googlegroups.com>
<Pine.GSO.4.64.0705072330240.24382@westnet.com>
<22749.1178599033@sss.pgh.pa.us>
<Pine.GSO.4.64.0705082302170.29385@westnet.com>
On Tue, 2007-05-08 at 23:31 -0400, Greg Smith wrote:
>
> My issue wasn't with the idea, it was with the implementation. When I
> have my newbie hat on, it adds a layer of complexity that isn't needed for
> simple installs.
I find it very hard to agree with that.
As a newbie I install postgresql and have a database server installed,
and operating. The fact that the DB files are installed somewhere
like /var/lib/postgresql/8.1/main is waaay beyond newbie.
At that point I can "createdb" or "createuser", but I _do_ _not_ need to
know anything about the cluster stuff until there is more than one DB on
the machine.
The Debian wrappers all default appropriately for the single-cluster
case, so having a single cluster has added _no_ perceivable complexity
for a newbie (as it should).
If you have a second cluster, whether it's the same Pg version or not,
things necessarily start to get complicated. OTOH I haven't had any
problem explaining to people that the --cluster option applies, and
there are sane ways to make that default to a reasonable thing as well.
All in all I think that the Debian scripts are excellent. I'm sure
there are improvements that could be made, but overall they don't get in
the way, they do the right thing in the minimal case, and they give the
advanced user a lot more choices about multiple DB instances on the same
machine.
Cheers,
Andrew McMillan.
-------------------------------------------------------------------------
Andrew @ Catalyst .Net .NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St
DDI: +64(4)803-2201 MOB: +64(272)DEBIAN OFFICE: +64(4)499-2267
Open Source: the difference between trust and antitrust
-------------------------------------------------------------------------
Attachments:
signature.asc (application/pgp-signature, 188B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: andrew@catalyst.net.nz, gsmith@gregsmith.com
Subject: Re: Best OS for Postgres 8.2
In-Reply-To: <1179038060.4722.43.camel@hippy.mcmillan.net.nz>
References: <1178574927.533849.90730@e51g2000hsg.googlegroups.com> <Pine.GSO.4.64.0705072330240.24382@westnet.com> <22749.1178599033@sss.pgh.pa.us> <Pine.GSO.4.64.0705082302170.29385@westnet.com> <1179038060.4722.43.camel@hippy.mcmillan.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox