public inbox for [email protected]
help / color / mirror / Atom feedRe: [GENERAL] Do we need more emphasis on backup?
22+ messages / 11 participants
[nested] [flat]
* Re: [GENERAL] Do we need more emphasis on backup?
@ 2004-07-05 19:09 Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-06 22:01 ` Re: [GENERAL] Do we need more emphasis on backup? Peter Eisentraut <[email protected]>
0 siblings, 2 replies; 22+ messages in thread
From: Bruce Momjian @ 2004-07-05 19:09 UTC (permalink / raw)
To: PostgreSQL-general <[email protected]>; pgsql-docs
pgman wrote:
> Jim Seymour wrote:
> > Tom Lane <[email protected]> wrote:
> > >
> > [snip]
> > >
> > > We do need to point out that you're only as reliable as your last
> > > backup. I'm not sure exactly where to say this.
> > [snip]
> > >
> >
> > Hmph. Backups are for mitigation against a catastrophic failure
> > destroying or corrupting main storage. And even then: Subtle errors
> > can induce data corruption that may go un-noticed until it's too late.
> > (I.e.: The last correct backups have been over-written, retired, so
> > old they've become unreadable, so old the data's no longer useful,
> > etc.)
> >
> > My position is that your data is only as reliable as your hardware,
> > period. Use cheap (usually PC, sorry) hardware and, well... I wonder
> > how many people are aware of the fact that the cheaper PCs don't even
> > have parity memory anymore? Then there are the issues with IDE
> > drives. (Don't recall those, exactly - don't use 'em.)
>
> There is a basic misconception that all PC hardware is created equal ---
> that hard drives, mother boards, and RAM are all the same because they
> are all PC-compatible. Compatible != Similar Quality.
>
> Not sure where we would document this. :-(
>
> Running BSD, I have always had to buy server-class hardware for my home
> machines, and I never regretted it nor had a problem.
Should I add an FAQ discussing hardware selection and the importance of
reliable hardware?
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
@ 2004-07-06 12:32 ` Jim Seymour <[email protected]>
2004-07-06 14:00 ` Re: Do we need more emphasis on backup? Alvaro Herrera <[email protected]>
2004-07-06 17:25 ` Re: Do we need more emphasis on backup? Anony Mous <[email protected]>
2004-07-12 00:19 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
1 sibling, 3 replies; 22+ messages in thread
From: Jim Seymour @ 2004-07-06 12:32 UTC (permalink / raw)
To: [email protected]
Bruce Momjian <[email protected]> wrote:
>
> pgman wrote:
> > Jim Seymour wrote:
[snip]
> > >
> > > My position is that your data is only as reliable as your hardware,
> > > period.
[snip]
> >
> > There is a basic misconception that all PC hardware is created equal ---
> > that hard drives, mother boards, and RAM are all the same because they
> > are all PC-compatible. Compatible != Similar Quality.
[snip]
>
> Should I add an FAQ discussing hardware selection and the importance of
> reliable hardware?
Scary to think that people who don't know enough about running a proper
server, and thus have to be *told* this, are admin'ing databases.
Start with: Gotta have ECC, or at least parity-checking, RAM.
Mention the (some kinds of?) IDE drives issue.
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.")
Jim
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
@ 2004-07-06 14:00 ` Alvaro Herrera <[email protected]>
2004-07-06 16:04 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 16:11 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2 siblings, 2 replies; 22+ messages in thread
From: Alvaro Herrera @ 2004-07-06 14:00 UTC (permalink / raw)
To: [email protected]
On Tue, Jul 06, 2004 at 08:32:15AM -0400, Jim Seymour wrote:
> Bruce Momjian <[email protected]> wrote:
> > Should I add an FAQ discussing hardware selection and the importance of
> > reliable hardware?
>
> Scary to think that people who don't know enough about running a proper
> server, and thus have to be *told* this, are admin'ing databases.
Maybe it's scary for people in the US or the western/wealthier Europe.
But people also live in other parts of the world (I could even mention
that real people do live in places like Iraq and they even have
computers there).
For us rest-of-the-worlders, it's not always possible to get top of the
line hardware. I am somewhat lucky because I live in a country where
people can afford an UPS. Some people are not.
Of course you can talk about the value of the data and how much good
hardware can help you not lose that data -- but truth is, people need to
make an economical analysis on the worthiness of such protection, and
while some of them will be able to afford redundant battery backed SCSI
RAID controllers, some others won't be able to buy an UPS.
So I think it's a good idea to mention that better hardware can be
helpful. But don't make that sound like if you don't have it, it's the
end of the world or the admin is an uneducated moron.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Hoy es el primer día del resto de mi vida"
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-06 14:00 ` Re: Do we need more emphasis on backup? Alvaro Herrera <[email protected]>
@ 2004-07-06 16:04 ` Bruce Momjian <[email protected]>
1 sibling, 0 replies; 22+ messages in thread
From: Bruce Momjian @ 2004-07-06 16:04 UTC (permalink / raw)
To: Alvaro Herrera <[email protected]>; +Cc: [email protected]
Alvaro Herrera wrote:
> On Tue, Jul 06, 2004 at 08:32:15AM -0400, Jim Seymour wrote:
>
> > Bruce Momjian <[email protected]> wrote:
>
> > > Should I add an FAQ discussing hardware selection and the importance of
> > > reliable hardware?
> >
> > Scary to think that people who don't know enough about running a proper
> > server, and thus have to be *told* this, are admin'ing databases.
>
> Maybe it's scary for people in the US or the western/wealthier Europe.
> But people also live in other parts of the world (I could even mention
> that real people do live in places like Iraq and they even have
> computers there).
>
> For us rest-of-the-worlders, it's not always possible to get top of the
> line hardware. I am somewhat lucky because I live in a country where
> people can afford an UPS. Some people are not.
>
> Of course you can talk about the value of the data and how much good
> hardware can help you not lose that data -- but truth is, people need to
> make an economical analysis on the worthiness of such protection, and
> while some of them will be able to afford redundant battery backed SCSI
> RAID controllers, some others won't be able to buy an UPS.
>
> So I think it's a good idea to mention that better hardware can be
> helpful. But don't make that sound like if you don't have it, it's the
> end of the world or the admin is an uneducated moron.
Good point. I will write up some text for the FAQ and post it. I will
emphasize that there is great variation in the quality of PC-compatible
hardware, and mention a few specific examples.
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-06 14:00 ` Re: Do we need more emphasis on backup? Alvaro Herrera <[email protected]>
@ 2004-07-06 16:11 ` Jim Seymour <[email protected]>
1 sibling, 0 replies; 22+ messages in thread
From: Jim Seymour @ 2004-07-06 16:11 UTC (permalink / raw)
To: [email protected]
Alvaro Herrera <[email protected]> wrote:
>
> On Tue, Jul 06, 2004 at 08:32:15AM -0400, Jim Seymour wrote:
>
> > Bruce Momjian <[email protected]> wrote:
>
> > > Should I add an FAQ discussing hardware selection and the importance of
> > > reliable hardware?
> >
> > Scary to think that people who don't know enough about running a proper
> > server, and thus have to be *told* this, are admin'ing databases.
>
[snip]
> For us rest-of-the-worlders, it's not always possible to get top of the
> line hardware.
[snip]
There's a difference between "not knowing your should" and "not being
able to do it." I addressed cluelessness, not economic ability.
>
[snip]
>
> So I think it's a good idea to mention that better hardware can be
> helpful.
"Helpful?" Hmmm... You know, recently there was a "consumer alert"
item during one of the major U.S. TV networks' news shows. It seems
that all kinds of counterfeit products are making it into the stores
here. Even after-market automotive brake pads made of nothing but
compressed and painted/dyed vegetable matter. Needless to say, using
brake bads made of proper brake pad material is "helpful." ;)
Somebody's *ability* to employ proper hardware does not affect whether
or not it's advisable to do so. This isn't a "rich" vs. "poor" issue.
If you cannot do it, you cannot do it, and that's that. But that does
not lessen the importance of knowing you should.
> But don't make that sound like if you don't have it, it's the
> end of the world or the admin is an uneducated moron.
If your db destructs due to an undetected RAM problem (undetected
because your computer has not even parity error detection) and the data
in that db is "life or death" critical to your business, it might well
be the end of the world as far as your business is concerned.
Jim
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
@ 2004-07-06 17:25 ` Anony Mous <[email protected]>
2004-07-06 20:48 ` Re: Do we need more emphasis on backup? Christopher Petrilli <[email protected]>
2 siblings, 1 reply; 22+ messages in thread
From: Anony Mous @ 2004-07-06 17:25 UTC (permalink / raw)
To: [email protected]
Scary if the person has a DBA background. But there are lots of people,
like myself, who find themselves doing this sort of work and do not have the
formal training (small business, small db, but still an important part of
the business IS). Now, I know my limits and I would not take on the task of
administering a high-volume, mission-critical DB. Nonetheless, there are
many tips, tricks, and gotcha's that I have yet to learn.
I welcome an FAQ on this subject and genuinely appreciate the efforts of
those who create it. It will make me a better "wanna-be"!
-----Original Message-----
From: Jim Seymour [mailto:[email protected]]
Sent: July 6, 2004 6:32 AM
To: [email protected]
Subject: Re: Do we need more emphasis on backup?
Bruce Momjian <[email protected]> wrote:
>
> pgman wrote:
> > Jim Seymour wrote:
[snip]
> > >
> > > My position is that your data is only as reliable as your hardware,
> > > period.
[snip]
> >
> > There is a basic misconception that all PC hardware is created equal ---
> > that hard drives, mother boards, and RAM are all the same because they
> > are all PC-compatible. Compatible != Similar Quality.
[snip]
>
> Should I add an FAQ discussing hardware selection and the importance of
> reliable hardware?
Scary to think that people who don't know enough about running a proper
server, and thus have to be *told* this, are admin'ing databases.
Start with: Gotta have ECC, or at least parity-checking, RAM.
Mention the (some kinds of?) IDE drives issue.
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.")
Jim
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-06 17:25 ` Re: Do we need more emphasis on backup? Anony Mous <[email protected]>
@ 2004-07-06 20:48 ` Christopher Petrilli <[email protected]>
2004-07-06 22:36 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
0 siblings, 1 reply; 22+ messages in thread
From: Christopher Petrilli @ 2004-07-06 20:48 UTC (permalink / raw)
To: Anony Mous <[email protected]>; +Cc: [email protected]
On Tue, 06 Jul 2004 11:25:07 -0600, Anony Mous <[email protected]> wrote:
> Scary if the person has a DBA background. But there are lots of people,
> like myself, who find themselves doing this sort of work and do not have the
> formal training (small business, small db, but still an important part of
> the business IS). Now, I know my limits and I would not take on the task of
> administering a high-volume, mission-critical DB. Nonetheless, there are
> many tips, tricks, and gotcha's that I have yet to learn.
>
> I welcome an FAQ on this subject and genuinely appreciate the efforts of
> those who create it. It will make me a better "wanna-be"!
One thing this strikes me as is an opportunity to help shape the
perception of DBAs and "real" databases versus "toy" databases.
Various products have gotten a lot of people out there running
databases with lots of mission criticle data in them, but they're
trusting a lot of slip-shod software and not putting into place any
proceedures to deal with backups and other things.
For example, I recently dealt with a customer who was using another
database, and had been running backups religiously for the past year.
The problem? The backups were of a live database, and it turned out
when they tried to restore, it was unable to get the tables back into
a position where they were usable without dropping a huge amount of
data from the tables, and then rebuilding indexes. A pain. All because
they'd not taken the right steps.
If the PostgreSQL community can help put together a "best practices"
guide, that will help all database people, but it will also help show
the PostgreSQL community as being more "serious." I'm more than happy
to contribute practices, and things, as well as help edit other
people's work, but I can't "lead" such an effort right now.
Chris
--
| Christopher Petrilli
| [email protected]
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-06 17:25 ` Re: Do we need more emphasis on backup? Anony Mous <[email protected]>
2004-07-06 20:48 ` Re: Do we need more emphasis on backup? Christopher Petrilli <[email protected]>
@ 2004-07-06 22:36 ` Jim Seymour <[email protected]>
0 siblings, 0 replies; 22+ messages in thread
From: Jim Seymour @ 2004-07-06 22:36 UTC (permalink / raw)
To: [email protected]
Christopher Petrilli <[email protected]> wrote:
>
[snip]
>
> If the PostgreSQL community can help put together a "best practices"
> guide, that will help all database people, but it will also help show
> the PostgreSQL community as being more "serious."
[snip]
*That* would be most welcome!
Jim
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
@ 2004-07-12 00:19 ` Bruce Momjian <[email protected]>
2004-07-12 00:54 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 07:31 ` Re: Do we need more emphasis on backup? Richard A Lough <[email protected]>
2 siblings, 2 replies; 22+ messages in thread
From: Bruce Momjian @ 2004-07-12 00:19 UTC (permalink / raw)
To: [email protected]
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?
---------------------------------------------------------------------------
Jim Seymour wrote:
>
> Bruce Momjian <[email protected]> wrote:
> >
> > pgman wrote:
> > > Jim Seymour wrote:
> [snip]
> > > >
> > > > My position is that your data is only as reliable as your hardware,
> > > > period.
> [snip]
> > >
> > > There is a basic misconception that all PC hardware is created equal ---
> > > that hard drives, mother boards, and RAM are all the same because they
> > > are all PC-compatible. Compatible != Similar Quality.
> [snip]
> >
> > Should I add an FAQ discussing hardware selection and the importance of
> > reliable hardware?
>
> Scary to think that people who don't know enough about running a proper
> server, and thus have to be *told* this, are admin'ing databases.
>
> Start with: Gotta have ECC, or at least parity-checking, RAM.
>
> Mention the (some kinds of?) IDE drives issue.
>
> 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.")
>
> Jim
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 00:19 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
@ 2004-07-12 00:54 ` Jim Seymour <[email protected]>
2004-07-12 01:09 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-12 01:10 ` Re: Do we need more emphasis on backup? Doug McNaught <[email protected]>
1 sibling, 2 replies; 22+ messages in thread
From: Jim Seymour @ 2004-07-12 00:54 UTC (permalink / raw)
To: [email protected]
Bruce Momjian <[email protected]> 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
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 00:19 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-12 00:54 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
@ 2004-07-12 01:09 ` Bruce Momjian <[email protected]>
1 sibling, 0 replies; 22+ messages in thread
From: Bruce Momjian @ 2004-07-12 01:09 UTC (permalink / raw)
To: [email protected]
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 <[email protected]> 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
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 00:19 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-12 00:54 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
@ 2004-07-12 01:10 ` Doug McNaught <[email protected]>
2004-07-12 01:37 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-12 03:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
1 sibling, 2 replies; 22+ messages in thread
From: Doug McNaught @ 2004-07-12 01:10 UTC (permalink / raw)
To: [email protected]
[email protected] (Jim Seymour) writes:
> 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..."
Wrong. :)
You are sentenced to go read Strunk and White again.
-Doug
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 00:19 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-12 00:54 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 01:10 ` Re: Do we need more emphasis on backup? Doug McNaught <[email protected]>
@ 2004-07-12 01:37 ` Bruce Momjian <[email protected]>
2004-07-12 02:11 ` Re: Do we need more emphasis on backup? Scott Marlowe <[email protected]>
2004-07-12 03:02 ` Re: Do we need more emphasis on backup? Joel <[email protected]>
1 sibling, 2 replies; 22+ messages in thread
From: Bruce Momjian @ 2004-07-12 01:37 UTC (permalink / raw)
To: Doug McNaught <[email protected]>; +Cc: [email protected]
Doug McNaught wrote:
> [email protected] (Jim Seymour) writes:
>
> > 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..."
>
> Wrong. :)
>
> You are sentenced to go read Strunk and White again.
Text adjusted:
<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 you are concerned about reliability
and performance it is wise to research your hardware options thoroughly. Our
email lists can be used to discuss hardware options and tradeoffs.</P>
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 00:19 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-12 00:54 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 01:10 ` Re: Do we need more emphasis on backup? Doug McNaught <[email protected]>
2004-07-12 01:37 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
@ 2004-07-12 02:11 ` Scott Marlowe <[email protected]>
1 sibling, 0 replies; 22+ messages in thread
From: Scott Marlowe @ 2004-07-12 02:11 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: Doug McNaught <[email protected]>; [email protected]
On Sun, 2004-07-11 at 19:37, Bruce Momjian wrote:
> Doug McNaught wrote:
> > [email protected] (Jim Seymour) writes:
> >
> > > 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..."
> >
> > Wrong. :)
> >
> > You are sentenced to go read Strunk and White again.
>
> Text adjusted:
>
> <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 you are concerned about reliability
> and performance it is wise to research your hardware options thoroughly. Our
> email lists can be used to discuss hardware options and tradeoffs.</P>
Further, a system should be burned in and have all the components
thoroughly tested. Brand new computers can, and often do, have broken
or misbehaving hardware. While relatively simple tasks like installing
an operating system or browsing the web only use a small portion of a
computer's resources, running a database relies on all of it working
properly. Basically, it all boils down to to this, if you're not sure
of your hardware, you shouldn't be building a database server with it,
and you can't be sure of your hardware without testing it.
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 00:19 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-12 00:54 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 01:10 ` Re: Do we need more emphasis on backup? Doug McNaught <[email protected]>
2004-07-12 01:37 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
@ 2004-07-12 03:02 ` Joel <[email protected]>
2004-07-12 03:59 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
1 sibling, 1 reply; 22+ messages in thread
From: Joel @ 2004-07-12 03:02 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: Doug McNaught <[email protected]>; [email protected]
> ... PostgreSQL will run on almost any hardware,
> but if you are building a server where you are concerned about reliability
> and performance it is wise to research your hardware options thoroughly. ...
That's okay, of course. But I'll suggest the following as food for
thought
PostgreSQL will run on almost any hardware, but,
if you are building a server where you are concerned
about reliability and performance, it is wise to
research your hardware options thoroughly.
or
PostgreSQL will run on almost any hardware, but,
especially where reliability and performance are
required, it is wise to research your
hardware options thoroughly.
(where/when)
--
Joel <[email protected]>
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 00:19 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-12 00:54 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 01:10 ` Re: Do we need more emphasis on backup? Doug McNaught <[email protected]>
2004-07-12 01:37 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-12 03:02 ` Re: Do we need more emphasis on backup? Joel <[email protected]>
@ 2004-07-12 03:59 ` Bruce Momjian <[email protected]>
2004-07-12 05:12 ` Re: Do we need more emphasis on backup? Joel <[email protected]>
0 siblings, 1 reply; 22+ messages in thread
From: Bruce Momjian @ 2004-07-12 03:59 UTC (permalink / raw)
To: Joel <[email protected]>; +Cc: Doug McNaught <[email protected]>; [email protected]
Joel wrote:
> > ... PostgreSQL will run on almost any hardware,
> > but if you are building a server where you are concerned about reliability
> > and performance it is wise to research your hardware options thoroughly. ...
>
> That's okay, of course. But I'll suggest the following as food for
> thought
>
> PostgreSQL will run on almost any hardware, but,
> if you are building a server where you are concerned
> about reliability and performance, it is wise to
> research your hardware options thoroughly.
>
> or
>
> PostgreSQL will run on almost any hardware, but,
> especially where reliability and performance are
> required, it is wise to research your
> hardware options thoroughly.
New text:
<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 reliability and performance are important it is wise to
research your hardware options thoroughly. Our email lists can be used
to discuss hardware options and tradeoffs.</P>
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 00:19 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-12 00:54 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 01:10 ` Re: Do we need more emphasis on backup? Doug McNaught <[email protected]>
2004-07-12 01:37 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-12 03:02 ` Re: Do we need more emphasis on backup? Joel <[email protected]>
2004-07-12 03:59 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
@ 2004-07-12 05:12 ` Joel <[email protected]>
0 siblings, 0 replies; 22+ messages in thread
From: Joel @ 2004-07-12 05:12 UTC (permalink / raw)
To: [email protected]
> New text:
>
> <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 reliability and performance are important it is wise to
> research your hardware options thoroughly. Our email lists can be used
> to discuss hardware options and tradeoffs.</P>
I like that, too.
(And now, after a break with real-world grammars, back to the cold,
cruel world of mechanical parsers. ;)
--
Joel <[email protected]>
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 00:19 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-12 00:54 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 01:10 ` Re: Do we need more emphasis on backup? Doug McNaught <[email protected]>
@ 2004-07-12 03:32 ` Jim Seymour <[email protected]>
1 sibling, 0 replies; 22+ messages in thread
From: Jim Seymour @ 2004-07-12 03:32 UTC (permalink / raw)
To: [email protected]
Doug McNaught <[email protected]> wrote:
>
> [email protected] (Jim Seymour) writes:
>
> > 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..."
>
> Wrong. :)
>
> You are sentenced to go read Strunk and White again.
I stand corrected. I always used to put the comma before "but," but
changed after reading somewhere, or thinking I had, that was incorrect
for certain sentence structures.
Neither of my style guides supports what I said earlier, so I cannot
imagine whence I got that idea.
Jim
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Re: Do we need more emphasis on backup? Jim Seymour <[email protected]>
2004-07-12 00:19 ` Re: Do we need more emphasis on backup? Bruce Momjian <[email protected]>
@ 2004-07-12 07:31 ` Richard A Lough <[email protected]>
1 sibling, 0 replies; 22+ messages in thread
From: Richard A Lough @ 2004-07-12 07:31 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: [email protected]
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
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [GENERAL] Do we need more emphasis on backup?
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
@ 2004-07-06 22:01 ` Peter Eisentraut <[email protected]>
1 sibling, 0 replies; 22+ messages in thread
From: Peter Eisentraut @ 2004-07-06 22:01 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; PostgreSQL-general <[email protected]>; pgsql-docs
Bruce Momjian wrote:
> Should I add an FAQ discussing hardware selection and the importance
> of reliable hardware?
I'm not a fan of having N "FAQs" for N topics. Just put it into the
documentation.
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [GENERAL] Do we need more emphasis on backup?
@ 2004-07-06 22:24 Bruce Momjian <[email protected]>
2004-07-07 13:43 ` Re: [GENERAL] Do we need more emphasis on backup? Kaarel <[email protected]>
0 siblings, 1 reply; 22+ messages in thread
From: Bruce Momjian @ 2004-07-06 22:24 UTC (permalink / raw)
To: Peter Eisentraut <[email protected]>; +Cc: PostgreSQL-general <[email protected]>; pgsql-docs
Peter Eisentraut wrote:
> Bruce Momjian wrote:
> > Should I add an FAQ discussing hardware selection and the importance
> > of reliable hardware?
>
> I'm not a fan of having N "FAQs" for N topics. Just put it into the
> documentation.
No, I was thinking of adding an FAQ _item_ about it, not a new FAQ.
--
Bruce Momjian | http://candle.pha.pa.us
[email protected] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 22+ messages in thread
* Re: [GENERAL] Do we need more emphasis on backup?
2004-07-06 22:24 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
@ 2004-07-07 13:43 ` Kaarel <[email protected]>
0 siblings, 0 replies; 22+ messages in thread
From: Kaarel @ 2004-07-07 13:43 UTC (permalink / raw)
To: Bruce Momjian <[email protected]>; +Cc: Peter Eisentraut <[email protected]>; PostgreSQL-general <[email protected]>; pgsql-docs
>>I'm not a fan of having N "FAQs" for N topics. Just put it into the
>>documentation.
>
>
> No, I was thinking of adding an FAQ _item_ about it, not a new FAQ.
>
I think it would actually make a nice subchapter of the official
documentation. Although not strictly PostgreSQL specific but a "best
practices" section under Administration and with a reference from
Introduction would be good.
Kaarel
^ permalink raw reply [nested|flat] 22+ messages in thread
end of thread, other threads:[~2004-07-12 07:31 UTC | newest]
Thread overview: 22+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-05 19:09 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-06 12:32 ` Jim Seymour <[email protected]>
2004-07-06 14:00 ` Alvaro Herrera <[email protected]>
2004-07-06 16:04 ` Bruce Momjian <[email protected]>
2004-07-06 16:11 ` Jim Seymour <[email protected]>
2004-07-06 17:25 ` Anony Mous <[email protected]>
2004-07-06 20:48 ` Christopher Petrilli <[email protected]>
2004-07-06 22:36 ` Jim Seymour <[email protected]>
2004-07-12 00:19 ` Bruce Momjian <[email protected]>
2004-07-12 00:54 ` Jim Seymour <[email protected]>
2004-07-12 01:09 ` Bruce Momjian <[email protected]>
2004-07-12 01:10 ` Doug McNaught <[email protected]>
2004-07-12 01:37 ` Bruce Momjian <[email protected]>
2004-07-12 02:11 ` Scott Marlowe <[email protected]>
2004-07-12 03:02 ` Joel <[email protected]>
2004-07-12 03:59 ` Bruce Momjian <[email protected]>
2004-07-12 05:12 ` Joel <[email protected]>
2004-07-12 03:32 ` Jim Seymour <[email protected]>
2004-07-12 07:31 ` Richard A Lough <[email protected]>
2004-07-06 22:01 ` Peter Eisentraut <[email protected]>
2004-07-06 22:24 Re: [GENERAL] Do we need more emphasis on backup? Bruce Momjian <[email protected]>
2004-07-07 13:43 ` Kaarel <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox