Re: 8.2.15 pitr/00000001.history - Mailing list pgsql-admin

From Ray Stell
Subject Re: 8.2.15 pitr/00000001.history
Date
Msg-id 20100324205444.GB21072@cns.vt.edu
Whole thread Raw
In response to 8.2.15 pitr/00000001.history  (Ray Stell <stellr@cns.vt.edu>)
Responses Re: 8.2.15 pitr/00000001.history  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
On Wed, Mar 24, 2010 at 01:10:31PM -0400, Ray Stell wrote:
>  2010-03-24 12:38:36.357 EDT,,3,,, LOG:  restore_command = "cp /home/postgresql/fms/wals/%f %p"
>    cp: cannot stat `/home/postgresql/fms/wals/00000001.history': No such file or directory

patience, young padawan:

2010-03-24 12:38:47.028 EDT,,31,,, LOG:  restored log file "0000000100000028000000EA" from archive
cp: cannot stat `/home/postgresql/fms/wals/00000002.history': No such file or directory
2010-03-24 12:38:47.032 EDT,,32,,, LOG:  selected new timeline ID: 2
cp: cannot stat `/home/postgresql/fms/wals/00000001.history': No such file or directory
2010-03-24 12:38:47.876 EDT,,33,,, LOG:  archive recovery complete
2010-03-24 12:38:49.478 EDT,,34,,, LOG:  database system is ready
2010-03-24 12:38:49.520 EDT,,1,,, LOG:  archived transaction log file "00000002.history"

src/backend/access/transam/xlog.c
        /*
         * Consider whether we need to assign a new timeline ID.
         *
         * If we are doing an archive recovery, we always assign a new ID.

pgsql-admin by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: How to use an alias name in the current select
Next
From: Bruce Momjian
Date:
Subject: Re: 8.2.15 pitr/00000001.history