From: | Radosław Smogura <rsmogura(at)softperience(dot)eu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>, Dick Kniep <dick(dot)kniep(at)lindix(dot)nl>, Andreas Kretschmer <akretschmer(at)spamfence(dot)net> |
Subject: | Re: Shit happens |
Date: | 2011-01-02 13:10:18 |
Message-ID: | 201101021410.18946.rsmogura@softperience.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 tricky as file system undelete, and it will
have same requirements as.
Here I found some link (I gooled "postgresql find deleted tuples"):
http://postgresql.1045698.n5.nabble.com/Restore-deleted-rows-td2005963.html
I think I saw quite interesting idea of "trash" for vaccumed tuples.
Kind regards,
Radosław Smogura
http://www.softperience.eu
Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> Sunday 02 January 2011
13:35:29
> 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 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.
>
> I suppose you did already try restoring that dump and applying the log
> files to it and that failed?
>
> Alban Hertroys
>
> --
> Screwing up is an excellent way to attach something to the ceiling.
>
>
> !DSPAM:737,4d20711d11541020214904!
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremy Harris | 2011-01-02 13:54:47 | Re: problem updating from form |
Previous Message | Joel Jacobson | 2011-01-02 13:04:10 | Finding recursive dependencies |