Hi! Try with this:
-----Mensaje original----- De: Anna Kanevsky [SMTP:[EMAIL PROTECTED] Enviado el: Jueves 2 de Octubre de 2003 20:45 Para: 'Stephan Szabo' CC: '[EMAIL PROTECTED]' 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:[EMAIL PROTECTED] > Enviado el: Jueves 30 de Octubre de 2003 08:32 > Para: [EMAIL PROTECTED] > 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. > > ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
