Re: [GENERAL] Shit happens

2011-01-03 Thread Jeff Davis
On Sun, 2011-01-02 at 10:31 +0100, Dick Kniep wrote: 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

Re: [GENERAL] Shit happens

2011-01-03 Thread Craig Ringer
On 01/02/2011 11:19 PM, Dick Kniep wrote: 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

Re: [GENERAL] Shit happens

2011-01-02 Thread Dick Kniep
- Van: Andreas Kretschmer akretsch...@spamfence.net Verzonden: za 01-01-11 10:04:11 Aan: pgsql-general@postgresql.org; Onderwerp: Re: [GENERAL] Shit happens Dick Kniep dick.kn...@lindix.nl wrote: Hi list, Happy newyear to all of you. We use WAL files for backup purposes. Now we

Re: [GENERAL] Shit happens

2011-01-02 Thread Alban Hertroys
On 2 Jan 2011, at 13:19, Dick Kniep wrote: 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

Re: [GENERAL] Shit happens

2011-01-02 Thread Radosław Smogura
Hi, I can only think, You could try to parse page files. If you didn't do VACCUM FULL you could try to restore it, if those rows was not overwritten after VACCUM (normal). Maybe some internal guys can give you answer (if e.g. VACCUM (nomral) zeros row). The programm to restore will bo so

Re: [GENERAL] Shit happens

2011-01-02 Thread Dick Kniep
- Van: Andreas Kretschmer akretsch...@spamfence.net Verzonden: za 01-01-11 10:04:11 Aan: pgsql-general@postgresql.org; Onderwerp: Re: [GENERAL] Shit happens Dick Kniep dick.kn...@lindix.nl wrote: Hi list, Happy newyear to all of you. We use WAL files for backup purposes. Now we need

[GENERAL] Shit happens

2011-01-01 Thread Dick Kniep
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

Re: [GENERAL] Shit happens

2011-01-01 Thread Andreas Kretschmer
Dick Kniep dick.kn...@lindix.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