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 614E38B9B9E for ; Tue, 1 Feb 2005 17:02:43 +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 92865-01 for ; Tue, 1 Feb 2005 17:02:32 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 0B0BE8B9B26 for ; Tue, 1 Feb 2005 17:02:32 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j11H2Vg5015480; Tue, 1 Feb 2005 12:02:31 -0500 (EST) To: Morus Walter Cc: pgsql-admin@postgresql.org Subject: Re: Online Backup and WAL archives In-reply-to: <16895.32035.914311.612690@tanto-xipolis.de> References: <16895.32035.914311.612690@tanto-xipolis.de> Comments: In-reply-to Morus Walter message dated "Tue, 01 Feb 2005 13:59:15 +0100" Date: Tue, 01 Feb 2005 12:02:31 -0500 Message-ID: <15479.1107277351@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/7 X-Sequence-Number: 16175 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