Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 4FAF09FA5F7 for ; Fri, 29 Sep 2006 17:53:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 78590-08 for ; Fri, 29 Sep 2006 20:53:25 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id CAA919F95E1 for ; Fri, 29 Sep 2006 17:53:24 -0300 (ADT) Received: (qmail 13799 invoked by uid 500); 29 Sep 2006 21:03:32 -0000 Date: Fri, 29 Sep 2006 16:03:32 -0500 From: Bruno Wolff III To: Chan Michael Cc: pgsql-admin@postgresql.org Subject: Re: How can I restore from WAL log? [PG 7.3] Message-ID: <20060929210332.GA11512@wolff.to> Mail-Followup-To: Bruno Wolff III , Chan Michael , pgsql-admin@postgresql.org References: <20060928141619.70631.qmail@web30502.mail.mud.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060928141619.70631.qmail@web30502.mail.mud.yahoo.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/380 X-Sequence-Number: 23294 On Thu, Sep 28, 2006 at 22:16:19 +0800, Chan Michael wrote: > Hi, > > I am new to PostgreSQL and now want to know how can I recover from a database crash. If you are just talking about the server dying unexpectedly, you recover by restarting it. Doing this should recover all transactions. Note that if your hard drives a lying to you about write completion, this might not work.