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.
Regards,
Sanjay