Re: Shit happens

From: Dick Kniep <dick(at)lindix(dot)nl>
To: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Shit happens
Date: 2011-01-02 09:31:01
Message-ID: vmime.4d2045d5.80f.1d6d81ef6d71e9@mail.pl20
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi list,

Thanks for the clear answer. However, this is the simple answer that is also in the manual. Yes I know it is not directly possible to get that data, but I am quite desparate to get the data back. If one way or another the data is (except for the 4 days we really have no data for) accessible, we will write a program to recover the data into the production database. So if anyone of you knows about a way to access the actual data in the WAL file (or a reference where to find enough information to do this) I would be very happy.

Cheers,
D. Kniep

-----Oorspronkelijk bericht-----
Van: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
Verzonden: za 01-01-11 10:04:11
Aan: pgsql-general(at)postgresql(dot)org;
Onderwerp: Re: [GENERAL] Shit happens

> Dick Kniep <dick(dot)kniep(at)lindix(dot)nl> wrote:
>
> > Hi list,
> >
> > Happy newyear to all of you.
> >
> > We use WAL files for backup purposes. Now we need to restore up to a
> > certain date in december, we have a base backup from october 24th, but
> > the WAL files start only at october 28th. Is there a way that we can
> > use the WAL files to recover data up to half december anyway? I know
>
> No. You can't fill the gap.
>
>
> Andreas
> --
> Really, I'm not out to destroy Microsoft. That will just be a completely
> unintentional side effect. (Linus Torvalds)
> "If I was god, I would recompile penguin with --enable-fly." (unknown)
> Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
>
> --
> 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
>
> !DSPAM:4d1eee0b160842018316037!
>
>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Harald Armin Massa 2011-01-02 11:20:47 Re: problem updating from form
Previous Message Karen Springer 2011-01-02 08:31:43 problem updating from form