Re: Standby server does not start with base backup

On Sat, Jun 18, 2011 at 10:57, Sanjay Rao <srao(at)noida(dot)interrasystems(dot)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/