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 58C77D1B260 for ; Mon, 28 Jun 2004 15:18:48 -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 30472-07 for ; Mon, 28 Jun 2004 18:18:43 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 2B4A2D1B1B4 for ; Mon, 28 Jun 2004 15:18:40 -0300 (ADT) Received: (qmail 16859 invoked by uid 500); 28 Jun 2004 18:25:13 -0000 Date: Mon, 28 Jun 2004 13:25:13 -0500 From: Bruno Wolff III To: Jose Almeida Cc: pgsql-admin@postgresql.org Subject: Re: Recover from a media failure Message-ID: <20040628182513.GA16820@wolff.to> Mail-Followup-To: Jose Almeida , pgsql-admin@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6i 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: 200406/354 X-Sequence-Number: 14014 On Mon, Jun 28, 2004 at 17:49:21 +0100, Jose Almeida wrote: > > Can someone explain me how can i recover (media failure) until last > transaction from a backup (something like archivelog in Oracle db)? > > In Oracle if i make a backup on instant t1 and a datafile be corrupt on > instant t2 (t2>t1), then i can restore from backup and apply archivelogs to > recover until t2. Right now you can't do this. Some version of this will probably be available with 7.5. Feature freeze will be happening this week and you can check to see if PITR made it in. A production version of 7.5 probably won't be released until mid fall (October or November). (There is also a chance that the release may be named 8.0 instead of 7.5.)