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 7B4558B9B63 for ; Tue, 1 Feb 2005 19:47:50 +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 06534-10 for ; Tue, 1 Feb 2005 19:47:42 +0000 (GMT) Received: from mail.deg.cc (mail.deg.cc [64.139.134.201]) by svr1.postgresql.org (Postfix) with ESMTP id F0FEF8B9B5B for ; Tue, 1 Feb 2005 19:47:42 +0000 (GMT) Received: from deg.cc (kyle.deg.cc [198.70.16.205]) by mail.deg.cc (Postfix) with ESMTP id 2176356219; Tue, 1 Feb 2005 14:47:35 -0500 (EST) Message-ID: <41FFDCDC.4030207@deg.cc> Date: Tue, 01 Feb 2005 14:47:40 -0500 From: Pallav Kalva User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.2) Gecko/20040308 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Morus Walter , pgsql-admin@postgresql.org Subject: Re: Online Backup and WAL archives References: <16895.32035.914311.612690@tanto-xipolis.de> <15479.1107277351@sss.pgh.pa.us> In-Reply-To: <15479.1107277351@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/9 X-Sequence-Number: 16177 Hi Tom, 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 Thanks, Pallav Tom Lane wrote: >Morus Walter writes: > > >>The documentation says >>' To make use of this backup, you will need to keep around all the >>WAL segment files generated at or after the starting time of the backup. ' >>Now I'm wondering how much of these WAL segment files do I really need >>in order to recover the databases to a consistent state. >> >> > >If you are satisfied with recovering to the state shortly after you >completed the backup, then it would be sufficient to have a set of WAL >files spanning the time period in which the backup is done. I'm dubious >that this is necessarily an improvement over a pg_dump backup, though. > > > >>I expect the online backup to faster on recovery than an SQL dump, since >>the latter would imply recreation of indexes during recovery. >> >> > >Is that assumption founded on any hard evidence? > > regards, tom lane > >---------------------------(end of broadcast)--------------------------- >TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match > > >