Skip site navigation (1) Skip section navigation (2)

Re: Read deleted record

From: Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com>
To: Muhammad Soultani <soultani(at)acternity(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Read deleted record
Date: 2011-01-25 12:02:22
Message-ID: AANLkTim5vTV_3SfVXsWRCOB4Y8u7rVTZzCbYH7sHVL-6@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

Probably this http://www.pgcon.org/2010/schedule/events/234.en.html
maight help you the pdf of presentation can be found
here:www.postgresql.jp/events/pgcon09j/doc/A2-2.pdf

2011/1/21 Muhammad Soultani <soultani(at)acternity(dot)com>:
> 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.
>
>
>
> I have tried to post this in to pgsql-general, unfortunately got no
> response..
>
>
>
> best regards,
>
> Soultani
>
>



-- 
Łukasz Brodziak
"What if everyting around You isn't quite as it seems,
What if all the world You think You know is an inelaborate dream
When You look at Your reflection is that all you want it to be
What if You could look right through the cracks
Would You find Yourself...... Find Yourself afraid to see"

In response to

pgsql-admin by date

Next:From: alys brettDate: 2011-01-25 14:04:26
Subject: Replication to less secure slave server
Previous:From: French, MartinDate: 2011-01-25 06:49:34
Subject: Re: Warm Standby looking for already applied log files

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group