Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 79C829FBA43 for ; Mon, 14 May 2007 15:30:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 79668-03 for ; Mon, 14 May 2007 15:30:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 46FB89FB9F1 for ; Mon, 14 May 2007 15:30:15 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id B90055645B; Mon, 14 May 2007 13:30:13 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Mon, 14 May 2007 13:30:09 -0500 Date: Mon, 14 May 2007 13:30:09 -0500 From: "Jim C. Nasby" To: Lorraine Mancuso Cc: pgsql-admin@postgresql.org Subject: Re: Recovery question Message-ID: <20070514183009.GV69517@nasby.net> References: <4639FC99.4070400@scranton.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4639FC99.4070400@scranton.edu> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070514:mancusol1@scranton.edu::vw3SqJCFR6JmLW2C:000000000000000 00000000000000000000000041B4 X-Hashcash: 1:20:070514:pgsql-admin@postgresql.org::Tc5CbQMrkXvvMmjb:00000000000 0000000000000000000000004Aw1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/114 X-Sequence-Number: 25434 On Thu, May 03, 2007 at 11:15:37AM -0400, Lorraine Mancuso wrote: > Hi, > > I am new to Postgres and had a few questions. We are testing the > recovery of a database cluster. We have read the documentation and have > been able to recover successfully but we were wondering about the > contents of the ARCHIVE_STATUS subdirectory. It appears that it is OK > for this directory to be entry during recovery. I just wanted to verify > that this is correct. Yes, that's OK. That directory is just used as a means to tell the archiver what logs it can archive. > Also, is there a way to search the archives for all notes on a > particular subject? http://archives.postgresql.org/ > Is this ADMIN list the appropriate forum for backup and recovery > questions? Yes. -- Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)