Skip site navigation (1) Skip section navigation (2)

aborting startup due to startup process failure

From: "George Wilk" <gwilk(at)ellacoya(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: aborting startup due to startup process failure
Date: 2007-06-28 19:55:29
Message-ID: 006101c7b9be$479dfed0$ (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
I posted to this group before with the same topic but nobody replied.
Please, provide some feedback if you can.

I am running a warm standby server, which executes the following command in
a recovery mode:



while (test ! -f /var/ipsc/WAL/$1 && ! $triggered)


    echo waiting for file: $1


    sleep 30


    if test -f /var/ipsc/pgsql/trigger


         echo --- trigger found         ---

         echo --- exiting recovery mode ---






if ( ! $triggered)


  cp /var/ipsc/WAL/$1 $2


  exit 133



Recovery command works just fine restoring data from the WAL files scp'd
from the primary server.  While in the recovery mode, when I create the
trigger file breaking the while loop in recovery command, postgres does not
go gently into the active database mode.  Here is output:


waiting for file: 00000001000000000000003A

--- trigger found ---

--- exiting recovery mode ---

FATAL:  could not restore file "00000001000000000000003A" from archive:
return code 34048

LOG:  startup process (PID 13994) exited with exit code 1

LOG:  aborting startup due to startup process failure


After finding the trigger file my recovery_cmd returns non-zero code.  Why
am I still getting FATAL:  could not restore file ?

Both my primary and standby servers run on Solaris 10 under SMF.  When the
standby server is attempting to change mode from recovery to regular
database mode, there might be a race condition there between SMF trying to
restart the server and the server trying to restart itself. or am I just


Thanks in advance for your comments.





pgsql-admin by date

Next:From: Kevin GrittnerDate: 2007-06-28 21:16:48
Subject: Re: aborting startup due to startup process failure
Previous:From: Raymond O'DonnellDate: 2007-06-28 18:43:23
Subject: Re: [GENERAL] i need a rad/ide open source for work with postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group