Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 9212B13364DE for ; Fri, 21 Jan 2011 00:18:22 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 48280-07 for ; Fri, 21 Jan 2011 04:18:15 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mo-p00-ob.rzone.de (mo-p00-ob.rzone.de [81.169.146.160]) by mail.postgresql.org (Postfix) with ESMTP id C7BDD1337B53 for ; Fri, 21 Jan 2011 00:18:13 -0400 (AST) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; t=1295583490; l=3885; s=domk; d=acternity.com; h=Content-Type:MIME-Version:Date:Subject:To:From:X-RZG-CLASS-ID: X-RZG-AUTH; bh=omCiewZQ+q4sWANMUgseyrMQomI=; b=gn5sclpVOb/lAj85WvJ3tfQWdlpTEjdJcKZ7PsHYjCOczaQ41JL4Hv0eJKgd0p4rg8f JbGS9Zo4PET18MLfseR6YQU2j4ayY7uapVOW3fY1kHmX1gPtNJpGDi0YyXHga/ntmuYHN 5qmlGuvy3ZDz72KBihtaJMPAjl9+mHPTneE= X-RZG-AUTH: :P2MReVSpdfasNUzJAHXkVWO9xK5NSTT1I6ZpmTiPxLGwv9a/EwS9Qd7yud5L+Oo= X-RZG-CLASS-ID: mo00 Received: from zouotaPC ([202.148.3.11]) by post.strato.de (cohen mo27) (RZmta 24.12) with ESMTP id k01ab7n0KM6Oqj for ; Fri, 21 Jan 2011 05:18:08 +0100 (MET) From: "Muhammad Soultani" To: Subject: Read deleted record Date: Fri, 21 Jan 2011 11:17:54 +0700 Message-ID: <000c01cbb922$2f49bf60$8ddd3e20$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000D_01CBB95C.DBA89760" X-Mailer: Microsoft Office Outlook 12.0 Content-Language: en-us Thread-Index: Acu5IiuotnENwMsQRai6Hxj/v4J5bQ== x-cr-hashedpuzzle: BXgD Cu+q DlNM D1hA E0in FhcF F4Et GNtS G375 HUWq HjJV IKWW JDS4 Kggo KkE/ Ktv2; 1; cABnAHMAcQBsAC0AYQBkAG0AaQBuAEAAcABvAHMAdABnAHIAZQBzAHEAbAAuAG8AcgBnAA==; Sosha1_v1; 7; {98187126-2427-4E82-A0E3-18E95F000FA4}; cwBvAHUAbAB0AGEAbgBpAEAAYQBjAHQAZQByAG4AaQB0AHkALgBjAG8AbQA=; Fri, 21 Jan 2011 04:17:52 GMT; UgBlAGEAZAAgAGQAZQBsAGUAdABlAGQAIAByAGUAYwBvAHIAZAA= x-cr-puzzleid: {98187126-2427-4E82-A0E3-18E95F000FA4} X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201101/136 X-Sequence-Number: 36576 This is a multipart message in MIME format. ------=_NextPart_000_000D_01CBB95C.DBA89760 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit 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 ------=_NextPart_000_000D_01CBB95C.DBA89760 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

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

------=_NextPart_000_000D_01CBB95C.DBA89760--