Re: Restoring a database from a file system snapshot

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: Restoring a database from a file system snapshot
Дата
Msg-id 48B6470E.3090204@postnewspapers.com.au
обсуждение исходный текст
Ответ на Re: Restoring a database from a file system snapshot  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Do I have a corrupted database?
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Restoring a database from a file system snapshot