Re: missing history file

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "George Wilk" <gwilk(at)ellacoya(dot)com>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: missing history file
Date: 2007-06-29 17:12:08
Message-ID: 4684F718.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>>> On Fri, Jun 29, 2007 at 11:47 AM, in message <5332(dot)1183135679(at)sss(dot)pgh(dot)pa(dot)us>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2007-06-29 17:29:06 Re: missing history file
Previous Message Radhika Sambamurti 2007-06-29 16:50:57 Linking libraries problem after Postgres-8.2.0 install]