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 AA434D1B1AB
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Mon, 12 Jul 2004 04:26:58 -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 69036-06
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Mon, 12 Jul 2004 07:27:01 +0000 (GMT)
Received: from ced2.sheugh.com (host213-123-246-212.in-addr.btopenworld.com
	[213.123.246.212])
	by svr1.postgresql.org (Postfix) with ESMTP id CDEF2D1B17B
	for <pgsql-general@postgresql.org>;
	Mon, 12 Jul 2004 04:26:52 -0300 (ADT)
Received: from richard by ced2.sheugh.com with local (Exim 3.36 #1 (Debian))
	id 1BjvHJ-00031K-00; Mon, 12 Jul 2004 07:31:09 +0000
Date: Mon, 12 Jul 2004 07:31:08 +0000
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: pgsql-general@postgresql.org
Subject: Re: Do we need more emphasis on backup?
Message-ID: <20040712073108.GA10721@mail.sheugh.com>
Reply-To: ralough@iee.org
References: <20040706123215.6E477430E@jimsun.linxnet.com>
	<200407120019.i6C0JME17078@candle.pha.pa.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <200407120019.i6C0JME17078@candle.pha.pa.us>
User-Agent: Mutt/1.5.6+20040523i
From: Richard A Lough <richard@sheugh.com>
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/504
X-Sequence-Number: 63103

On Sun, Jul 11, 2004 at 08:19:22PM -0400, Bruce Momjian wrote:
> 
> New FAQ added:

I would suggest the following: 

     <H4><A name="3.11">3.11</A>) What computer hardware should I use?</H4>
 
     <P>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. ECC RAM, SCSI, and quality 
     motherboards have proven to be more reliable and to offer better 
     performance than less expensive hardware. Where cost of hardware is 
     your primary concern, proven and frequent backups may provide 
     reassurance that valued information can be retreived after component 
     or system failure. With inexpensive hardware there is greater risk of 
     introducing subtle errors which degrade the credibility of your data. 
     Our email lists can be used to discuss hardware options and tradeoffs.
     </P>
 
---------------------------------------//--------------------------------

IMHO the guy with cheapo hardware is the one with most need of advice. It
may be prudent to put together some figures to give some notion of a cost 
effective backup for him. 

Following on from this, I hear that serial ATA drives are likely to 
replace IDE drives and will offer performance similar to SCSI. 

But, I am still a novice in database matters, just my 2d.

HTH

Richard A Lough