pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: George Wilk <gwilk@ellacoya.com>
To: pgsql-admin@postgresql.org
Subject: Re: missing history file
Date: Fri, 29 Jun 2007 11:22:03 -0400
Message-ID: <00d201c7ba61$3f078540$0d7ba8c0@ellacoya.com> (raw)
In-Reply-To: <12838.1183128750@sss.pgh.pa.us>

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@sss.pgh.pa.us] 
Sent: Friday, June 29, 2007 10:53 AM
To: Simon Riggs
Cc: George Wilk; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] missing history file 

"Simon Riggs" <simon@2ndquadrant.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





view thread (12+ messages)  latest in thread

Message-ID: <00d201c7ba61$3f078540$0d7ba8c0@ellacoya.com>
Permalink:  ../00d201c7ba61$3f078540$0d7ba8c0@ellacoya.com/
Also on:    postgresql.org/message-id/00d201c7ba61$3f078540$0d7ba8c0@ellacoya.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: gwilk@ellacoya.com
  Subject: Re: missing history file
  In-Reply-To: <00d201c7ba61$3f078540$0d7ba8c0@ellacoya.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox