Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 0F8DF9FBA28 for ; Fri, 29 Jun 2007 13:48:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 25179-03 for ; Fri, 29 Jun 2007 13:48:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 57D7B9FB9E3 for ; Fri, 29 Jun 2007 13:48:33 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l5TGlxbC005333; Fri, 29 Jun 2007 12:47:59 -0400 (EDT) To: "George Wilk" cc: pgsql-admin@postgresql.org Subject: Re: missing history file In-reply-to: <00d201c7ba61$3f078540$0d7ba8c0@ellacoya.com> References: <00d201c7ba61$3f078540$0d7ba8c0@ellacoya.com> Comments: In-reply-to "George Wilk" message dated "Fri, 29 Jun 2007 11:22:03 -0400" Date: Fri, 29 Jun 2007 12:47:59 -0400 Message-ID: <5332.1183135679@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/304 X-Sequence-Number: 25972 "George Wilk" writes: > 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? History files are only created when you do a PITR recovery that stops short of the end of WAL (ie, you gave it an explicit stopping point criterion). So basically they never appear except by manual intervention on the primary server. A standby script should probably handle requests for them by looking to see if they're available, and returning 'em if so, but not waiting if they are not. Offhand I would recommend the same strategy for any requested filename that's not a plain WAL segment file (ie, all hex digits). regards, tom lane