From: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
---|---|
To: | Joe Carr <joe(dot)carr(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: FATAL: the database system is starting up |
Date: | 2010-09-23 12:48:05 |
Message-ID: | AANLkTinbvceOpPnpDQ_2RsXfbq10FM5M05MC34kcuFWj@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Thu, Sep 23, 2010 at 1:37 AM, Joe Carr <joe(dot)carr(at)gmail(dot)com> wrote:
> 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.
Did you set hot_standby to true in postgresql.conf of the standby server?
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
From | Date | Subject | |
---|---|---|---|
Next Message | Brad Nicholson | 2010-09-23 12:53:05 | Re: long-running autovacuum tasks |
Previous Message | Lukasz Brodziak | 2010-09-23 12:37:57 | Re: pgdview |