Re: missing history file

Tom,

When and by what process is the history file being created? My standby
server seems to be looking for it when put back in the recovery mode, after
functioning as primary for a while.
How should I handle missing history file in my script?

Cheers,
~george

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Friday, June 29, 2007 10:53 AM
To: Simon Riggs
Cc: George Wilk; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] missing history file

"Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
> Just ignore 00000001. Recovery will work fine even if absent. Don't
> ignore all history files though, just that one. Hmmm, come to think of
> it, why is it requesting it at all? We should just skip that request.

No, because then people would misdesign their recovery scripts to not
be able to deal with not finding a history file. As things are, they
will certainly be exposed to that case in any testing they do. If we
optimize this call away, then they won't see the case until they're in
very deep doo-doo.

regards, tom lane