Re: Restoring a database from a file system snapshot

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: William Garrison <postgres(at)mobydisk(dot)com>, Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Restoring a database from a file system snapshot
Date: 2008-08-28 06:34:54
Message-ID: 48B6470E.3090204@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera wrote:

> It is consistent only if it was taken when the postmaster was down.

OR if you are able to take a point-in-time snapshot at the volume level,
say using LVM or some SAN management tool. The effect is the same as if
the server is hardware reset unexpectedly, in that it requires recovery
when next started but is otherwise fine.

Of course, you still need all of your database including the logs etc.

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-08-28 07:11:05 Re: Restoring a database from a file system snapshot
Previous Message Craig Ringer 2008-08-28 06:18:28 Re: Do I have a corrupted database?