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@xxxxxxxxxxxxx] Sent: Friday, June 29, 2007 10:53 AM To: Simon Riggs Cc: George Wilk; pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] missing history file "Simon Riggs" <simon@xxxxxxxxxxxxxxx> 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
