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$0d7ba8c0@ellacoya.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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:
triggered=false
while (test ! -f /var/ipsc/WAL/$1 && ! $triggered)
do
echo waiting for file: $1
sleep 30
if test -f /var/ipsc/pgsql/trigger
then
echo --- trigger found ---
echo --- exiting recovery mode ---
triggered=true
fi
done
if ( ! $triggered)
then
cp /var/ipsc/WAL/$1 $2
else
exit 133
fi
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
hallucinating.
Thanks in advance for your comments.
Cheers,
~george
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2007-06-28 21:16:48 | Re: aborting startup due to startup process failure |
Previous Message | Raymond O'Donnell | 2007-06-28 18:43:23 | Re: [GENERAL] i need a rad/ide open source for work with postgresql |