Обсуждение: 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. 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/
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. > >