Re: missing history file - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: missing history file
Date
Msg-id 4684F718.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: missing history file  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: missing history file  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
>>> On Fri, Jun 29, 2007 at 11:47 AM, in message <5332.1183135679@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> History files are only created when you do a PITR recovery that stops
> short of the end of WAL (ie, you gave it an explicit stopping point
> criterion).  So basically they never appear except by manual
> intervention on the primary server.  A standby script should probably
> handle requests for them by looking to see if they're available, and
> returning 'em if so, but not waiting if they are not.
>
> Offhand I would recommend the same strategy for any requested filename
> that's not a plain WAL segment file (ie, all hex digits).

I suspect that it's worth waiting for something like this, too?:

000000010000000A000000CF.0000E744.backup




pgsql-admin by date:

Previous
From: "Radhika Sambamurti"
Date:
Subject: Linking libraries problem after Postgres-8.2.0 install]
Next
From: Tom Lane
Date:
Subject: Re: missing history file