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

Поиск
Список
Период
Сортировка
От Chris Travers
Тема Re: Lost data Folder, but have WAL files--- How to recover the database ?? Windows
Дата
Msg-id CAKt_ZfspmEWNLLSYqnGAjO8qq=8ksk8CBuKcwHSDfrMN39KO9w@mail.gmail.com
обсуждение исходный текст
Ответ на Lost data Folder, but have WAL files--- How to recover the database ?? Windows  (chinnaobi <chinnaobi@gmail.com>)
Список pgsql-general
Дерево обсуждения


On Mon, Mar 5, 2012 at 6:38 PM, chinnaobi <chinnaobi@gmail.com> wrote:
Hi All,

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.

I don;t think you can recover from only the WAL archives.  However, if you have a base backup and a complete collection of WAL archives then recovery should be possible.  At that point it's basically standard WAL recovery.

So I guess the first step is to determine if you have this base backup (you would have taken one during replication setup and hopefully were taking them from time to time).

best Wishes,
Chris Travers

Thanks in advance.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Lost-data-Folder-but-have-WAL-files-How-to-recover-the-database-Windows-tp5539703p5539703.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

Предыдущее
От: Brian Trudal
Дата:
Сообщение: Single server multiple databases - extension
Следующее
От: Toby Corkindale
Дата:
Сообщение: ANALYSE on top-level of partitioned tables - required?