On Sat, Jun 18, 2011 at 10:57, Sanjay Rao <srao@noida.interrasystems.com> wrote:
> Hi,
>
> I am running a test setup for verifying the warm standby feature in Postgres
> 9.0 release. Both my Master (Win 7 Professional, 64 bit) & Standby (Win 7
> Professional, 64 bit) machines are having Postgres 9.0
> (postgresql-9.0.4-1-windows) installed & both are in our LAN environment.
>
> After taking a base backup of the master database using pg_start_backup() &
> copy of the data folder to Standby machine followed by pg_stop_backup() in
> Master, the Standby server is started. The Standby server logs show the
> following error and the standby Postgres server shuts down. After this it
> never starts
>
> 2011-06-18 13:56:32 IST LOG: entering standby mode
> 2011-06-18 13:56:32 IST LOG: streaming replication successfully connected
> to primary
> 2011-06-18 13:56:32 IST FATAL: the database system is starting up
> 2011-06-18 13:56:33 IST LOG: redo starts at 0/3000020
> 2011-06-18 13:56:33 IST FATAL: the database system is starting up
> 2011-06-18 13:56:34 IST LOG: consistent recovery state reached at 0/5000000
> 2011-06-18 13:56:34 IST FATAL: the database system is starting up
> 2011-06-18 13:56:35 IST FATAL: the database system is starting up
> 2011-06-18 13:56:36 IST FATAL: the database system is starting up
> 2011-06-18 13:56:37 IST FATAL: the database system is starting up
> 2011-06-18 13:56:38 IST FATAL: the database system is starting up
> 2011-06-18 13:56:39 IST FATAL: the database system is starting up
> .
> .
> .
> .and same message continues..
>
> I have attached the configuration files of standby server. Please help me if
> anybody have any such experience or know the exact cause of the issue.
That seems perfectly normal. There's nothing in those logs indicating
that the standby shut down - if it did, there should be some other
messages when that happens.
If you want to be able to actually connect to the slave, you need to
run in hot standby.
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
