Re: Only WAL archive left. Need to restore data.

From: bricklen <bricklen(at)gmail(dot)com>
To: Sergey Arlashin <sergeyarl(dot)maillist(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Only WAL archive left. Need to restore data.
Date: 2013-08-09 14:58:22
Message-ID: CAGrpgQ_eXUyhZOhfH35FpEpCzX5=eddRGn1H3Wf6VSSOXdj3ZQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Aug 9, 2013 at 4:06 AM, Sergey Arlashin <
sergeyarl(dot)maillist(at)gmail(dot)com> wrote:

> Hi,
> I have 2GB backup of WAL archive folder but the backup of postgres database
> cluster directory is lost.
> However I need to restore any data possible from these WAL logs.
>
> Is that possible? What do I do to get the data.
>
>
I haven't used it personally, but xlogdump might work somewhat:
https://github.com/snaga/xlogdump

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Lilian BENOIT 2013-08-09 17:25:09 PostgreSQL don't start
Previous Message Albe Laurenz 2013-08-09 11:43:17 Re: Only WAL archive left. Need to restore data.