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
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" |