Re: [ADMIN] FATAL: the database system is starting up

2010-09-29 Thread Joe Carr
Hello Fujii, Sorry for the delay in my response, and thank you very much for the help. I did not have the server configured to be a hot_standby in the postgresql.conf, and once I did replication is working perfectly for me. -Joe On Thu, Sep 23, 2010 at 8:48 AM, Fujii Masao wrote: > On Thu,

Re: [ADMIN] FATAL: the database system is starting up

2010-09-23 Thread Kevin Grittner
Joe Carr wrote: > and the "FATAL: the database system is starting up" message will > continue. I believe that you get that when there is an attempt to connect to a database which is in recovery mode. I think the pg_ctl program makes attempts for about one minute before it gives up. If you h

Re: [ADMIN] FATAL: the database system is starting up

2010-09-23 Thread Fujii Masao
On Thu, Sep 23, 2010 at 1:37 AM, Joe Carr 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

[ADMIN] FATAL: the database system is starting up

2010-09-23 Thread Joe Carr
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 PD