Thread: postgres console delete mistake

postgres console delete mistake

From

ameen eetemadi

Date:

30 October 2003, 10:32:55

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.

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.

Thanks

__________________________________
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears
http://launch.yahoo.com/promos/britneyspears/

Re: postgres console delete mistake

From

Sergio Pili

Date:

30 October 2003, 12:50:10

Hi!

Try with this:

-----Mensaje original-----
De:    Anna Kanevsky [SMTP:akanevsky@aahe.org]
Enviado el:    Jueves 2 de Octubre de 2003 20:45
Para:    'Stephan Szabo'
CC:    'pgsql-admin@postgresql.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@yahoo.com]
> Enviado el:    Jueves 30 de Octubre de 2003 08:32
> Para:    pgsql-admin@postgresql.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.
>
>