Обсуждение: Postgres 9.0 Replication - Problem in Starting up Standby Server

Поиск
Список
Период
Сортировка

Postgres 9.0 Replication - Problem in Starting up Standby Server

От
"Venkatesh"
Дата:

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

Вложения