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

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: chinnaobi <chinnaobi(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Lost data Folder, but have WAL files--- How to recover the database ?? Windows
Date: 2012-03-06 08:53:56
Message-ID: CA+U5nMJaSx-Z5F4n8CKXM7ab0Y1LEF58TeJdAtB80Q_h0sO7-w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Mar 6, 2012 at 2:38 AM, chinnaobi <chinnaobi(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Julien Rouhaud 2012-03-06 10:44:38 Re: [ADMIN] pg_dump : no tables were found.
Previous Message Piyush Lenka 2012-03-06 06:22:39 pg_dump : no tables were found.