FATAL: the database system is starting up

From: Joe Carr <joe(dot)carr(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: FATAL: the database system is starting up
Date: 2010-09-22 16:37:02
Message-ID: AANLkTi=P-KT=v+NGF+HbodG0rYCXc++J1++N8vGhA5A_@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello all,
OS = Windows Server 2003
PostGres = 9.0

I'm trying to bring up a second machine as a hot standby. When I attempted
to start the service on the second machine I receive the following :

2010-09-22 09:33:56 PDT LOG: database system was interrupted; last known up
at 2010-09-22 09:07:51 PDT
2010-09-22 09:33:56 PDT LOG: creating missing WAL directory
"pg_xlog/archive_status"
2010-09-22 09:33:56 PDT LOG: entering standby mode
2010-09-22 09:33:57 PDT FATAL: the database system is starting up
2010-09-22 09:33:57 PDT LOG: restored log file "00000001000000000000002E"
from archive
2010-09-22 09:33:57 PDT LOG: redo starts at 0/2E000020
2010-09-22 09:33:57 PDT LOG: consistent recovery state reached at
0/2F000000
2010-09-22 09:33:57 PDT LOG: streaming replication successfully connected
to primary
2010-09-22 09:33:58 PDT FATAL: the database system is starting up
2010-09-22 09:33:59 PDT FATAL: the database system is starting up

and the "FATAL: the database system is starting up" message will continue.

Do you know any steps to debug this message? I have a feeling it is a file
permissions error, but I cannot determine the cause.

Thanks beforehand for any assistance.

-Joe

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marc Fromm 2010-09-22 17:18:49 postgresql logs
Previous Message Tom Lane 2010-09-21 21:30:05 Re: pg_dump fails with the following error: "ERROR: cache lookup failed for index 1531353157"