From soultani@acternity.com Fri Jan 21 04:18:22 2011 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-- From lukasz.brodziak@gmail.com Tue Jan 25 12:02:31 2011 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 4B4C61337B54 for ; Tue, 25 Jan 2011 08:02:31 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 01440-03 for ; Tue, 25 Jan 2011 12:02:23 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iy0-f174.google.com (mail-iy0-f174.google.com [209.85.210.174]) by mail.postgresql.org (Postfix) with ESMTP id D4020133798E for ; Tue, 25 Jan 2011 08:02:22 -0400 (AST) Received: by iyj18 with SMTP id 18so5005549iyj.19 for ; Tue, 25 Jan 2011 04:02:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=/C0HOPigYSDlhJkMYPe+iclKr0uwTc9srcECRR4Ysqs=; b=a3zk3fcnIJHspP07PM4cGldlgON1vSG7EEHOGEaukniPKhZ4Ndc39sWmS9KbtBzEAa q0p5zg0Fx5QuVjU+dRfiS2QlptswMum/DkVZJurYCqVKouoJl4K0D6Vr/q/SdIJPgvZR zJoVGvug7H5rDp3LuVHmVkNCvKBxflyUyO68w= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=YYTRN0qzIs9r0JONCYdpsP/Ytg0BTvX3/GU5TxJMKiyBg+lpuxXUnXFM6kGqvQgprF LPp7rCjA4VMftIruvxa3BkfxLGFvuQNdqqQk49j0pw0TcFZ8L0Jrb8GaFLcwIouoJxsp q1/6uh/SlMZj+Rta20Qsojo4n09ZjqhWQxM5Y= MIME-Version: 1.0 Received: by 10.231.39.199 with SMTP id h7mr6413338ibe.157.1295956942640; Tue, 25 Jan 2011 04:02:22 -0800 (PST) Received: by 10.231.26.4 with HTTP; Tue, 25 Jan 2011 04:02:22 -0800 (PST) In-Reply-To: <000c01cbb922$2f49bf60$8ddd3e20$@com> References: <000c01cbb922$2f49bf60$8ddd3e20$@com> Date: Tue, 25 Jan 2011 13:02:22 +0100 Message-ID: Subject: Re: Read deleted record From: Lukasz Brodziak To: Muhammad Soultani Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_LOW=-0.7 X-Spam-Level: X-Archive-Number: 201101/156 X-Sequence-Number: 36596 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 : > Hi all.. > > > > Start from vacuum feature information from PGSQL helps documentation, it > telling me that Postgresql didn=E2=80=99t 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 > > --=20 =C5=81ukasz 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"