X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B845ED1B181 for ; Sun, 11 Jul 2004 21:54:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36555-04 for ; Mon, 12 Jul 2004 00:54:35 +0000 (GMT) Received: from jimsun.linxnet.com (jimsun.linxnet.com [64.32.196.134]) by svr1.postgresql.org (Postfix) with ESMTP id CF358D1B190 for ; Sun, 11 Jul 2004 21:54:30 -0300 (ADT) Received: by jimsun.linxnet.com (Postfix, from userid 332) id 84A594311; Sun, 11 Jul 2004 20:54:34 -0400 (EDT) To: pgsql-general@postgresql.org Subject: Re: Do we need more emphasis on backup? X-Sun-Charset: US-ASCII Reply-To: pgsql-general@postgresql.org In-Reply-To: <200407120019.i6C0JME17078@candle.pha.pa.us> Message-Id: <20040712005434.84A594311@jimsun.linxnet.com> Date: Sun, 11 Jul 2004 20:54:34 -0400 (EDT) From: jseymour@linxnet.com (Jim Seymour) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200407/386 X-Sequence-Number: 62985 Bruce Momjian wrote: > > > New FAQ added: > >

3.11) What computer hardware should I use?

> >

Because PC hardware is mostly compatible, people tend to believe that > all PC hardware is of equal quality. It is not. ECC RAM, SCSI, and > quality motherboards are more reliable and have better performance than > less expensive hardware. PostgreSQL will run on almost any hardware, > but if you are building a server where reliability and performance are > concerns, it is wise to research your hardware options thoroughly. Our > email lists can be used to discuss hardware options and tradeoffs.

> > Adjustments? Looks good to me. Succinct and non-judgemental. Well done! Oh, if you're accepting punctuation nits ;), in most cases, the comma should come after "but," not before it. So your sentence should read "PostgreSQL will run on almost any hardware but, if you are..." If you wanted to mention other issues to consider, you might include: > > --------------------------------------------------------------------------- > > Jim Seymour wrote: > > [snip] > > > > Mention that hardware RAID systems must have battery-backed write > > cache. (I actually had a RAID vendor, whose products no longer had > > batter-backed write cache, tell me "Just use a UPS.") Also desirable are a quality UPS, with monitoring on the server for graceful shutdown of the server on battery exhaustion, and redundant power supplies. Jim