On Sat, Jun 18, 2011 at 10:57, Sanjay Rao <srao@xxxxxxxxxxxxxxxxxxxxxxxx> 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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
