Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C178547632B for ; Fri, 24 Jan 2003 08:52:59 -0500 (EST) Received: from lakemtao03.cox.net (lakemtao03.cox.net [68.1.17.242]) by postgresql.org (Postfix) with ESMTP id 112704762E3 for ; Fri, 24 Jan 2003 08:52:59 -0500 (EST) Received: from [192.168.1.1] ([68.11.66.83]) by lakemtao03.cox.net (InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP id <20030124135303.BQWH8666.lakemtao03.cox.net@[192.168.1.1]> for ; Fri, 24 Jan 2003 08:53:03 -0500 Subject: Re: Crash Recovery From: Ron Johnson To: PgSQL Performance ML In-Reply-To: <2147483647.1043361178@[10.0.1.133]> References: <2147483647.1043361178@[10.0.1.133]> Content-Type: text/plain Organization: Message-Id: <1043416377.29437.70.camel@haggis> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.1 Date: 24 Jan 2003 07:52:57 -0600 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/279 X-Sequence-Number: 926 On Thu, 2003-01-23 at 21:32, Noah Silverman wrote: > To preface my question, we are still in the process of evaluating postgres > to determine if we want to switch our production environment over. > > I'm curious about where I can find documentation about crash recovery in > postgres. In mysql, there is a nice table recovery utility (myisamchk). > is there something similar in postgres? What do we do if a table or > database becomes corrupted? (I'm aware of backup techniques, but it isn't > feasible for some of our larger tables. We're already running on raid 5, > but can't do much more) Of course it's feasible!! If corporations can backup terrabyte-sized databases, then you can backup your comparatively puny DB. In fact, if your data is vital to your company, you *must* back it up. Otherwise, poof goes the company if the computer is destroyed. Now, it might cost some bucks to buy a tape drive, or a multi-loader, if you have *lots* of data, but it *can* be done... Btw, what happens if an obscure bug in the RAID controller shows is head, and starts corrupting your data? A table recovery utility wouldn't do squat, then... -- +---------------------------------------------------------------+ | Ron Johnson, Jr. mailto:ron.l.johnson@cox.net | | Jefferson, LA USA http://members.cox.net/ron.l.johnson | | | | "Fear the Penguin!!" | +---------------------------------------------------------------+