Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group