Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 3550F9FB58C for ; Fri, 29 Jun 2007 07:44:48 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 46757-04 for ; Fri, 29 Jun 2007 07:44:33 -0300 (ADT) X-Greylist: delayed 14:49:09.776242 by SQLgrey-1.7.5 Received: from mail02.ellacoya.com (67-135-29-172.dia.static.qwest.net [67.135.29.172]) by postgresql.org (Postfix) with ESMTP id 7572E9FB599 for ; Fri, 29 Jun 2007 07:44:43 -0300 (ADT) Received: from YZANGXP ([192.168.123.13]) by mail02.ellacoya.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 29 Jun 2007 06:44:42 -0400 From: "George Wilk" To: "'Tom Lane'" Cc: Subject: Re: aborting startup due to startup process failure Date: Fri, 29 Jun 2007 06:44:40 -0400 Message-ID: <007b01c7ba3a$7f093d90$0d7ba8c0@ellacoya.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: <3048.1183083368@sss.pgh.pa.us> Thread-Index: Ace585t5L9cC5m54RTysVhFOO0MgjgARhcgA X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-OriginalArrivalTime: 29 Jun 2007 10:44:42.0216 (UTC) FILETIME=[8006FE80:01C7BA3A] X-TM-AS-Product-Ver: SMEX-8.0.0.1181-5.000.1021-15266.003 X-TM-AS-Result: No--16.088600-4.000000-31 X-TM-AS-User-Approved-Sender: No X-TM-AS-User-Blocked-Sender: No X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/295 X-Sequence-Number: 25963 Tom, You nailed it right in the head! My bad... My exit code was causing the problem. Once I changed it to 1 the recovery mode exited and the database came up: waiting for file: 0000000100000000000000F2 --- trigger found --- --- exiting recovery mode --- exiting with 1 LOG: could not open file "pg_xlog/0000000100000000000000F2" LOG: redo done at 0/F1000070 file: 0000000100000000000000F1 path: pg_xlog/RECOVERYXLOG LOG: restored log file "0000000100000000000000F1" from archive LOG: archive recovery complete LOG: database system is ready Thanks to all who contributed to this thread - much obliged. Cheers, ~george -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Thursday, June 28, 2007 10:16 PM To: George Wilk Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] aborting startup due to startup process failure "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