X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2261A14B288F for ; Wed, 11 Aug 2004 10:48:24 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95237-08 for ; Wed, 11 Aug 2004 13:48:19 +0000 (GMT) Received: from orioninformationservices.com (oismail.com [213.173.245.221]) by svr1.postgresql.org (Postfix) with ESMTP id B7B8314B2877 for ; Wed, 11 Aug 2004 10:48:11 -0300 (ADT) Received: from [192.168.8.102] ([213.173.234.215]) (authenticated) by orioninformationservices.com (8.11.6/8.11.6) with ESMTP id i7BDodk23491 for ; Wed, 11 Aug 2004 15:50:39 +0200 Message-ID: <411A230B.4030405@orioninformationservices.com> Date: Wed, 11 Aug 2004 15:45:47 +0200 From: Jona User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Recover old record version Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/74 X-Sequence-Number: 14469 Hi, One of our developers has just managed to make an UPDATE on a table without any WHERE clause to restrict it. Thus a table with a few thousand records has suddenly become virtual identical. Currently no VACUUM has been run on that table (or the database for that matter) thus it should be possible to recover an old version of the records, right? I'm basing my assumption on the documentation which states that PostGre has better than row-level locking and keeps an old version of each record until a vacuum occours. How would I go about recovering one of the old version for all the records ?? Please advice! Cheers Jona