Обсуждение: Recovery question

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.

    Also, is there a way to search the archives for all notes on a
particular subject?

    Is this ADMIN list the appropriate forum for backup and recovery
questions?

Thanks alot!
Lorraine
University of Scranton
(using POSTGRES for Xythos on a Linux box)

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)