Re: postgres console delete mistake

Hi!

Try with this:

-----Mensaje original-----
De: Anna Kanevsky [SMTP:akanevsky(at)aahe(dot)org]
Enviado el: Jueves 2 de Octubre de 2003 20:45
Para: 'Stephan Szabo'
CC: 'pgsql-admin(at)postgresql(dot)org'
Asunto: Re: [ADMIN] Delete accident

Thank you everyone!
I got a load of responses, and don't want to keep anyone working at this.
the magic is in pgfsck! <http://svana.org/kleptog/pgsql/pgfsck.html>
-anya

Regards,

Sergio Pili

> -----Mensaje original-----
> De: ameen eetemadi [SMTP:ameen78101(at)yahoo(dot)com]
> Enviado el: Jueves 30 de Octubre de 2003 08:32
> Para: pgsql-admin(at)postgresql(dot)org
> Asunto: [ADMIN] postgres console delete mistake
>
> hello
> I accidentally deleted every recordes from my table
> whithout a back up for my data such as pg_dump.
> How can I restore
> them?
> I found that deleted data are alrealy in my databes
> files such as /var/lib/pgsql/data/base/*
> and transactions are loged in
> /var/lib/pgsql/data/pg_xlog/00000001,000000002
> but the file formats are not alrealy readable for me.
> I found a tool pg_filedump but I'm not found it usable
> for this problem.
> Is there a tool for data recovery in postgres.
>
>