Hi, I am running a test setup for verifying the hot standby feature in Postgres 9.0 release. Both my Master (Win 7 Professional, 32 bit) & Standby (Win 7 Professional, 32 bit) machines are having Postgres 9.0 (postgresql-9.0.3-1-windows) installed & both are in our LAN environment. After taking a hot 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 Postgres server shuts down 2011-03-22 13:01:58 IST FATAL: the database system is starting up 2011-03-22 13:01:59 IST FATAL: the database system is starting up 2011-03-22 13:02:00 IST FATAL: the database system is starting up 2011-03-22 13:02:01 IST FATAL: ShmemIndex entry size is wrong for data structure "Wal Sender Ctl": expected 16, actual 0 2011-03-22 13:02:01 IST FATAL: the database system is starting up 2011-03-22 13:02:02 IST FATAL: the database system is starting up 2011-03-22 13:02:03 IST FATAL: the database system is starting up 2011-03-22 13:02:04 IST FATAL: the database system is starting up 2011-03-22 13:02:05 IST FATAL: the database system is starting up 2011-03-22 13:02:06 IST FATAL: the database system is starting up 2011-03-22 13:02:07 IST FATAL: the database system is starting up 2011-03-22 13:02:08 IST FATAL: the database system is starting up 2011-03-22 13:02:09 IST FATAL: the database system is starting up 2011-03-22 13:02:10 IST FATAL: the database system is starting up 2011-03-22 13:02:11 IST FATAL: the database system is starting up 2011-03-22 13:02:12 IST FATAL: ShmemIndex entry size is wrong for data structure "Wal Sender Ctl": expected 16, actual 0 2011-03-22 13:02:12 IST FATAL: the database system is starting up 2011-03-22 13:02:13 IST FATAL: the database system is starting up 2011-03-22 13:02:15 IST FATAL: the database system is starting up 2011-03-22 13:02:16 IST FATAL: the database system is starting up 2011-03-22 13:02:17 IST FATAL: the database system is starting up 2011-03-22 13:02:23 IST FATAL: ShmemIndex entry size is wrong for data structure "Wal Sender Ctl": expected 16, actual 0 2011-03-22 13:02:34 IST FATAL: ShmemIndex entry size is wrong for data structure "Wal Sender Ctl": expected 16, actual 0 2011-03-22 13:02:45 IST FATAL: ShmemIndex entry size is wrong for data structure "Wal Sender Ctl": expected 16, actual 0 I have also attached the Master/Standy config files for your reference. Please help me in resolving this issue. Regds, Venkatesh |
<<attachment: postgres-replication.zip>>
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
