Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 9E6159FA1AF for ; Tue, 12 Jun 2007 13:19:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 39261-10 for ; Tue, 12 Jun 2007 13:19:10 -0300 (ADT) X-Greylist: delayed 22:44:03.349435 by SQLgrey-1.7.4 Received: from mx1.mail.bg (mx1.mail.bg [193.201.172.114]) by postgresql.org (Postfix) with ESMTP id 09D209FA166 for ; Tue, 12 Jun 2007 13:19:11 -0300 (ADT) Received: from localhost (unknown [10.0.0.193]) by mx1.mail.bg (Postfix) with ESMTP id 170258012E7E for ; Tue, 12 Jun 2007 19:19:10 +0300 (EEST) Received: from 194.12.229.193 ([194.12.229.193]) by mail.bg (mail.bG Webmail 4.0.1) with HTTP for ; Tue, 12 Jun 2007 19:19:09 +0300 Message-ID: <1181665149.b014150a4b253@mail.bg> Date: Tue, 12 Jun 2007 19:19:09 +0300 From: zz_11@mail.bg To: pgsql-admin@postgresql.org Subject: Re: How to restore updated records References: <1181583306.d9d10231a3c6c@mail.bg> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1251" Content-Disposition: inline Content-Transfer-Encoding: quoted-printable User-Agent: mail.bG Webmail 4.0-cvs X-Originating-IP: 194.12.229.193 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.962 tagged_above=0 required=5 tests=BAYES_50=0.001, NO_REAL_NAME=0.961 X-Spam-Level: X-Archive-Number: 200706/103 X-Sequence-Number: 25771 No, I do not have WAL archiving. I hope some one have done the hacking in postmaster. If no one have done this, my idea was to change the vacuum (or make e new copy). I am not familiar with pg code, but as I know by running vacuum, pg marks deleted records as free, and my idea was to mark this records as real record in the database (if it is possible). regards, ivan. > Ivan, > > if you have configured WAL archiving, you may want to > look at > http://www.postgresql.org/docs/8.1/static/backup-online.html, > especially paragraph '23.3..4. Timelines'. > > List: Maybe someone already hacked the postmaster to > extract deleted records?! > > HTH, Oliver. > > -----Ursprungliche Nachricht----- > Von: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org] Im Auftrag von > zz_11@mail.bg > Gesendet: Montag, 11. Juni 2007 19:35 > An: pgsql-admin@postgresql.org > Betreff: [ADMIN] How to restore updated records > > > > Hi all. > Sorry for my problem. > I am using pg on ~100 servers fro 5 y. without any > problems, > but this time I make a big mistake. > > A have a table tasks with about 20000 records. > The table have ID as pk and some other fields. > > I typed : update tasks set c1=3D'sss'; > instead update tasks setc1=3D'sss' where id=3D10; > > And the pg updated all my table tasks. > > I do not have any backup on this table. > Exists any way to restore the data> > After the mistake I stopped to execute any commands to > this > database and also I DO NOT HAVE running vacuum, vacuum > analyze ot vacuum full analyze on this table. > > I know pg stores the old copy of data, but I do not have > any > idea how to restore this deleted records. > > Pls., point me to any solution for this problem. > > Many thanks and best regards, > ivan. > > ----------------------------- > > SCENA - =C5=E4=E8=ED=F1=F2=E2=E5=ED=EE=F2=EE =C1=C5=C7=CF=CB=C0=D2=CD=CE = =F1=EF=E8=F1=E0=ED=E8=E5 =E7=E0 =EC=EE=E1=E8=EB=ED=E8 > =EA=EE=EC=F3=ED=E8=EA=E0=F6=E8=E8 =E8 =F2=E5=F5=ED=EE=EB=EE=E3=E8=E8. > http://www.bgscena.com/ > > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > > ---------------------------(end of > broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by > donating at > > http://www.postgresql.org/about/donate > > > ----------------------------- SCENA - =C5=E4=E8=ED=F1=F2=E2=E5=ED=EE=F2=EE =C1=C5=C7=CF=CB=C0=D2=CD=CE =F1= =EF=E8=F1=E0=ED=E8=E5 =E7=E0 =EC=EE=E1=E8=EB=ED=E8 =EA=EE=EC=F3=ED=E8=EA=E0= =F6=E8=E8 =E8 =F2=E5=F5=ED=EE=EB=EE=E3=E8=E8. http://www.bgscena.com/