Re: How can I restore from WAL log? [PG 7.3]

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Chan Michael <michael_kychan(at)yahoo(dot)com(dot)hk>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How can I restore from WAL log? [PG 7.3]
Date: 2006-09-29 21:03:32
Message-ID: 20060929210332.GA11512@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Sep 28, 2006 at 22:16:19 +0800,
Chan Michael <michael_kychan(at)yahoo(dot)com(dot)hk> 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-09-29 21:38:07 Re: autovacuum ignore tables
Previous Message Erik Jones 2006-09-29 18:51:59 Re: [GENERAL] Array assignment behavior (was Re: Stored procedure