Postgres Pro
Downloads
Home   >   mailing lists

Re: Only WAL archive left. Need to restore data. - Mailing list pgsql-admin

From bricklen
Subject Re: Only WAL archive left. Need to restore data.
Date
Msg-id CAGrpgQ_eXUyhZOhfH35FpEpCzX5=eddRGn1H3Wf6VSSOXdj3ZQ@mail.gmail.com
Whole thread Raw
In response to Only WAL archive left. Need to restore data.  (Sergey Arlashin <sergeyarl.maillist@gmail.com>)
List pgsql-admin
Tree view

On Fri, Aug 9, 2013 at 4:06 AM, Sergey Arlashin <sergeyarl.maillist@gmail.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

pgsql-admin by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: Only WAL archive left. Need to restore data.
Next
From: "Lilian BENOIT"
Date:
Subject: PostgreSQL don't start