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 10A755282E for ; Thu, 23 Jun 2005 15:24: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 01782-05 for ; Thu, 23 Jun 2005 18:24:45 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 0CEE45280D for ; Thu, 23 Jun 2005 15:24:43 -0300 (ADT) 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 j5NIOgeu007198; Thu, 23 Jun 2005 14:24:42 -0400 (EDT) To: Jeff Frost Cc: pgsql-admin@postgresql.org Subject: Re: restoring wal archive and pg_xlog dir In-reply-to: References: Comments: In-reply-to Jeff Frost message dated "Thu, 23 Jun 2005 10:55:04 -0700" Date: Thu, 23 Jun 2005 14:24:42 -0400 Message-ID: <7197.1119551082@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: 200506/174 X-Sequence-Number: 17929 Jeff Frost writes: > If the system will use the files in the archive in preference to the ones in > pg_xlog, how can this actually happen if it will not overwrite the contents of > pg_xlog? Segment files pulled from the archive are saved using temporary file names (and then deleted after being replayed). For obvious safety reasons, we try never to overwrite any xlog file in either the archive or local storage. > I also noticed that if there is not at least one wal archive available in > the archive or the pg_xlog dir, the restore errors out and exits. So the > base backup is really not complete without at least one wal archive > following it. Is this by design? Certainly. If you don't have wal data spanning the entire time that the base backup is being taken, the backup is useless because there's no way to make it consistent. regards, tom lane