Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 136C39FC249 for ; Thu, 28 Jun 2007 23:16:48 -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 74954-09 for ; Thu, 28 Jun 2007 23:16:42 -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 061D79FC265 for ; Thu, 28 Jun 2007 23:16:42 -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 l5T2G8OW003049; Thu, 28 Jun 2007 22:16:08 -0400 (EDT) To: "George Wilk" cc: pgsql-admin@postgresql.org Subject: Re: aborting startup due to startup process failure In-reply-to: <006101c7b9be$479dfed0$0d7ba8c0@ellacoya.com> References: <006101c7b9be$479dfed0$0d7ba8c0@ellacoya.com> Comments: In-reply-to "George Wilk" message dated "Thu, 28 Jun 2007 15:55:29 -0400" Date: Thu, 28 Jun 2007 22:16:08 -0400 Message-ID: <3048.1183083368@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/294 X-Sequence-Number: 25962 "George Wilk" writes: > I am running a warm standby server, which executes the following command in > a recovery mode: > [ when done: ] > exit 133 Did you pick that number out of a hat? Postgres thinks it means that the recovery command died horribly, and abandons the recovery as a safety measure. (Per Single Unix Spec, this exit code from a shell script would ordinarily mean that some program the shell called died with a signal 5.) Use "exit 1" or some low number like that to signal ordinary failure to find the requested xlog file. Numbers larger than about 125 mean catastrophic failure of the recovery command. regards, tom lane