| Lists: | pgsql-general |
|---|
| From: | chinnaobi <chinnaobi(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Lost data Folder, but have WAL files--- How to recover the database ?? Windows |
| Date: | 2012-03-06 02:38:44 |
| Message-ID: | 1331001524619-5539703.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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.
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.
| From: | Chris Travers <chris(dot)travers(at)gmail(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 03:11:57 |
| Message-ID: | CAKt_ZfspmEWNLLSYqnGAjO8qq=8ksk8CBuKcwHSDfrMN39KO9w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On Mon, Mar 5, 2012 at 6:38 PM, chinnaobi <chinnaobi(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
| 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 |
| 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