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@xxxxxxxxxxxxx> Verzonden: za 01-01-11 10:04:11 Aan: pgsql-general@xxxxxxxxxxxxxx; Onderwerp: Re: Shit happens > Dick Kniep <dick.kniep@xxxxxxxxx> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > !DSPAM:4d1eee0b160842018316037! > > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
