Re: Do we need more emphasis on backup?

OK, comma moved.  I didn't add those other items because I didn't want
the list to be anything near a complete list.


---------------------------------------------------------------------------

Jim Seymour wrote:
> 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073