Thread: read and restore deleted record
Hi all..
Start from vacuum feature information from PGSQL helps documentation, it telling me that Postgresql didn’t delete data permanently when we execute delete command, it just made the data invalid. By following this email archive :
http://archives.postgresql.org/pgsql-admin/2005-01/msg00176.php
I could get the table files, my question is, how could I read again the deleted record from that files.
Thank you and best regards,
Soultani
> Start from vacuum feature information from PGSQL helps documentation, it > telling me that Postgresql didn’t delete data permanently when we > execute delete command, it just made the data invalid. By following this > email archive : > > http://archives.postgresql.org/pgsql-admin/2005-01/msg00176.php > > I could get the table files, my question is, how could I read again the > deleted record from that files. I am interested to know it as well. -- Lu Ying
You read the doc about archiving and pitr. 2011/2/15, Emi Lu <emilu@encs.concordia.ca>: > >> Start from vacuum feature information from PGSQL helps documentation, it >> telling me that Postgresql didn’t delete data permanently when we >> execute delete command, it just made the data invalid. By following this >> email archive : >> >> http://archives.postgresql.org/pgsql-admin/2005-01/msg00176.php >> >> I could get the table files, my question is, how could I read again the >> deleted record from that files. > > I am interested to know it as well. > > -- > Lu Ying > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- ------------ pasman