Skip site navigation (1) Skip section navigation (2)

Re: missing history file

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "George Wilk" <gwilk(at)ellacoya(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: missing history file
Date: 2007-06-29 17:45:27
Message-ID: 4684FEE7.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
>>> On Fri, Jun 29, 2007 at 12:29 PM, in message <5750(dot)1183138146(at)sss(dot)pgh(dot)pa(dot)us>,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote: 
> "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
>> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
 



In response to

pgsql-admin by date

Next:From: Michael MonnerieDate: 2007-06-29 18:05:10
Subject: syslog: log line length?
Previous:From: Tom LaneDate: 2007-06-29 17:42:08
Subject: Re: Linking libraries problem after Postgres-8.2.0 install]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group