Re: missing history file - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: missing history file
Date
Msg-id 4684FEE7.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: missing history file  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
>>> On Fri, Jun 29, 2007 at 12:29 PM, in message <5750.1183138146@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
>> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> 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
>
> No, I don't think so.  AFAICS the slave server would only ask for one
> of those during its initial cold start from a base backup, and it'll be
> looking for the one that should have been generated at completion of
> that base backup.  If it ain't there, it's unlikely to appear later.

Fair enough.  It would have saved us some time if this was mentioned
in the warm standby documentation.  I'll try to put a doc patch together.

-Kevin




pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Linking libraries problem after Postgres-8.2.0 install]
Next
From: Michael Monnerie
Date:
Subject: syslog: log line length?