Re: Restoring a database from a file system snapshot - Mailing list pgsql-general

From Craig Ringer
Subject Re: Restoring a database from a file system snapshot
Date
Msg-id 48B6470E.3090204@postnewspapers.com.au
Whole thread Raw
In response to Re: Restoring a database from a file system snapshot  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Do I have a corrupted database?
Next
From: "Scott Marlowe"
Date:
Subject: Re: Restoring a database from a file system snapshot