Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9C00E9FA2DE for ; Sun, 13 May 2007 03:34:49 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 48874-08 for ; Sun, 13 May 2007 03:34:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 9ACD99FA1D8 for ; Sun, 13 May 2007 03:34:45 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mail1.catalyst.net.nz (godel.catalyst.net.nz [202.78.240.40]) by svr4.postgresql.org (Postfix) with ESMTP id 96F455AF8BB for ; Sun, 13 May 2007 06:34:44 +0000 (GMT) Received: from leibniz.catalyst.net.nz ([202.78.240.7] helo=[172.17.217.22]) by mail1.catalyst.net.nz with esmtpsa (TLS-1.0:RSA_ARCFOUR_MD5:16) (Exim 4.50) id 1Hn7f8-0000NL-GY; Sun, 13 May 2007 18:34:34 +1200 Subject: Re: Best OS for Postgres 8.2 From: Andrew McMillan To: Greg Smith Cc: pgsql-performance@postgresql.org In-Reply-To: References: <1178574927.533849.90730@e51g2000hsg.googlegroups.com> <22749.1178599033@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-xB3+aY1/Mw4ASkqjRZE/" Organization: Catalyst .Net Ltd Date: Sun, 13 May 2007 18:34:20 +1200 Message-Id: <1179038060.4722.43.camel@hippy.mcmillan.net.nz> Mime-Version: 1.0 X-Mailer: Evolution 2.10.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/242 X-Sequence-Number: 24632 --=-xB3+aY1/Mw4ASkqjRZE/ Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Tue, 2007-05-08 at 23:31 -0400, Greg Smith wrote: >=20 > My issue wasn't with the idea, it was with the implementation. When I=20 > have my newbie hat on, it adds a layer of complexity that isn't needed fo= r=20 > 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 ------------------------------------------------------------------------- --=-xB3+aY1/Mw4ASkqjRZE/ Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBGRrFsjJA0f48GgBIRAt8uAJ4202Hg3N8lhiyDFk2dX7WU7haYuACfcBb3 /jE3w3AT31c+M2tK41+iPVY= =Vdkh -----END PGP SIGNATURE----- --=-xB3+aY1/Mw4ASkqjRZE/--