On Thu, Sep 23, 2010 at 1:37 AM, Joe Carr <joe.carr@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
