Re: Lost data Folder, but have WAL files--- How to recover the database ?? Windows

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Lost data Folder, but have WAL files--- How to recover the database ?? Windows
Дата
Msg-id CA+U5nMJaSx-Z5F4n8CKXM7ab0Y1LEF58TeJdAtB80Q_h0sO7-w@mail.gmail.com
обсуждение исходный текст
Ответ на Lost data Folder, but have WAL files--- How to recover the database ?? Windows  (chinnaobi <chinnaobi@gmail.com>)
Список pgsql-general
On Tue, Mar 6, 2012 at 2:38 AM, chinnaobi <chinnaobi@gmail.com> wrote:

> Recently i was doing streaming replication, I lost the data folder on both
> the servers and left with WAL archives (some how).
>
> Can any one tell me how to recover database with WAL archives.
>
> Thanks in advance.

There are no standard tools to help in those situations, but my
company has performed many difficult recoveries where the database has
been partially or severely damaged; references are available. Partial
or full data recovery is often possible but obviously there is a cost
and I respect community members who choose not to take that route.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

В списке pgsql-general по дате отправления:

Предыдущее
От: Toby Corkindale
Дата:
Сообщение: ANALYSE on top-level of partitioned tables - required?
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: [ADMIN] pg_dump : no tables were found.