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 8033A8B9B30 for ; Wed, 2 Feb 2005 15:11:20 +0000 (GMT) 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 08740-06 for ; Wed, 2 Feb 2005 15:11:13 +0000 (GMT) Received: from mail.tanto.de (mail.tanto.de [213.61.178.43]) by svr1.postgresql.org (Postfix) with ESMTP id 7069F8B9B49 for ; Wed, 2 Feb 2005 15:11:15 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by mail.tanto.de (Postfix) with ESMTP id BB89C23B93 for ; Wed, 2 Feb 2005 16:11:16 +0100 (CET) Received: from mail.tanto.de ([127.0.0.1]) by localhost (mail.tanto.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12155-08 for ; Wed, 2 Feb 2005 16:11:16 +0100 (CET) Received: from tucholsky.office.tanto.de (tucholsky.office.tanto.de [10.0.0.35]) by mail.tanto.de (Postfix) with ESMTP id 9AEDA23B8E for ; Wed, 2 Feb 2005 16:11:16 +0100 (CET) Received: from tucholsky.office.tanto.de (morus@localhost [127.0.0.1]) by tucholsky.office.tanto.de (8.12.3/8.12.3/Debian-7.1) with ESMTP id j12FBP72027917 for ; Wed, 2 Feb 2005 16:11:25 +0100 Received: (from morus@localhost) by tucholsky.office.tanto.de (8.12.3/8.12.3/Debian-7.1) id j12FBPVk027913; Wed, 2 Feb 2005 16:11:25 +0100 Resent-From: Morus Walter Resent-Message-ID: <16896.60829.713601.120818@tanto-xipolis.de> Resent-Date: Wed, 2 Feb 2005 16:11:25 +0100 Resent-To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <16896.60593.751654.61839@tanto-xipolis.de> In-Reply-To: <4200E2DC.6020803@deg.cc> References: <16895.32035.914311.612690@tanto-xipolis.de> <15479.1107277351@sss.pgh.pa.us> <4200E2DC.6020803@deg.cc> X-Mailer: VM 7.03 under 21.4 (patch 6) "Common Lisp" XEmacs Lucid From: Morus Walter To: Pallav Kalva Subject: Re: Online Backup and WAL archives Date: Wed, 2 Feb 2005 16:07:29 +0100 X-Virus-Scanned: by amavisd-new at mail.tanto.de Q&A postmaster@tanto.de X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200502/14 X-Sequence-Number: 16182 Pallav Kalva writes: > > If I want to restore to a particular point in time lets say to the > point in time like a day back when one of my table was dropped > accidentally and if i want restore the archive log only to that > particular archive log file . what is the procedure we should follow ? > just keep the archive logs in the directory until the last archive log > file i need or is there a command something like " restore only until > at this archive log file " ? Also what happens to the transaction log > files in pg_xlog directory in this scenario ? do i have to still keep > them or they get created by themself since i am going a day back ? > > Is this possible in postgres 8 > Yes. That's what PITR is about. Read the manual for details. If you look at the recovery.conf.sample you'll find a variable recovery_target_time that must be set. Unless I missed something this isn't explicitly stated in the docs but the comment in the sample conf is pretty clear. Alternatively you can define a transaction id (recovery_target_xid). Of course you must have a backup created before the incident and all WALs up to the time of the incident. Morus