pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedOnly WAL archive left. Need to restore data.
3+ messages / 3 participants
[nested] [flat]
* Only WAL archive left. Need to restore data.
@ 2013-08-09 11:06 Sergey Arlashin <sergeyarl.maillist@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Sergey Arlashin @ 2013-08-09 11:06 UTC (permalink / raw)
To: pgsql-admin
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.
Thanks in advance.
--
Best regards,
Sergey Arlashin=
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Only WAL archive left. Need to restore data.
@ 2013-08-09 11:43 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: Sergey Arlashin <sergeyarl.maillist@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Albe Laurenz @ 2013-08-09 11:43 UTC (permalink / raw)
To: Sergey Arlashin *EXTERN* <sergeyarl.maillist@gmail.com>; pgsql-admin
Sergey Arlashin wrote:
> 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.
Unfortunately that is impossible.
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Only WAL archive left. Need to restore data.
@ 2013-08-09 14:58 bricklen <bricklen@gmail.com>
parent: Sergey Arlashin <sergeyarl.maillist@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: bricklen @ 2013-08-09 14:58 UTC (permalink / raw)
To: Sergey Arlashin <sergeyarl.maillist@gmail.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-08-09 14:58 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-08-09 11:06 Only WAL archive left. Need to restore data. Sergey Arlashin <sergeyarl.maillist@gmail.com>
2013-08-09 11:43 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2013-08-09 14:58 ` bricklen <bricklen@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox