Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id CE3689FB8DB for ; Mon, 11 Jun 2007 15:05:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 72888-04-3 for ; Mon, 11 Jun 2007 15:05:35 -0300 (ADT) X-Greylist: delayed 00:30:16.086072 by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 9AB849FBADD for ; Mon, 11 Jun 2007 15:05:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mx1.mail.bg (mx1.mail.bg [193.201.172.114]) by svr4.postgresql.org (Postfix) with ESMTP id A1EF45AF0B2 for ; Mon, 11 Jun 2007 17:35:14 +0000 (GMT) Received: from localhost (unknown [10.0.0.192]) by mx1.mail.bg (Postfix) with ESMTP id 50C278012ADF for ; Mon, 11 Jun 2007 20:35:06 +0300 (EEST) Received: from 194.12.229.193 ([194.12.229.193]) by mail.bg (mail.bG Webmail 4.0.1) with HTTP for ; Mon, 11 Jun 2007 20:35:06 +0300 Message-ID: <1181583306.d9d10231a3c6c@mail.bg> Date: Mon, 11 Jun 2007 20:35:06 +0300 From: zz_11@mail.bg To: pgsql-admin@postgresql.org Subject: How to restore updated records 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/91 X-Sequence-Number: 25759 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/