Re: Do we need more emphasis on backup?

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