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