Re: Do we need more emphasis on backup? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Do we need more emphasis on backup?
Date
Msg-id 200407120109.i6C19Pm05230@candle.pha.pa.us
Whole thread Raw
In response to Re: Do we need more emphasis on backup?  (jseymour@linxnet.com (Jim Seymour))
List pgsql-general
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 <pgman@candle.pha.pa.us> wrote:
> >
> >
> > New FAQ added:
> >
> >     <H4><A name="3.11">3.11</A>) What computer hardware should I use?</H4>
> >
> >     <P>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.</P>
> >
> > 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

pgsql-general by date:

Previous
From: jseymour@linxnet.com (Jim Seymour)
Date:
Subject: Re: Do we need more emphasis on backup?
Next
From: Doug McNaught
Date:
Subject: Re: Do we need more emphasis on backup?